Over 1 million tech questions and answers.

Solved: converting spreadsheet (.wks) to excel 07

Q: Solved: converting spreadsheet (.wks) to excel 07


I'm just wondering how to convert this spread sheet file (.wks) to excel 2007..

i know thats a lot of years in between the two programs but there must be a way to convert it.. or is there?

so i do need to open and re use the spread sheet but i don't know how i got that program in the first place.. so yer.

ive tried to convert it using excel 07' and was a fail. only came up with all differnt characters.

thanks for reading.

Preferred Solution: Solved: converting spreadsheet (.wks) to excel 07

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Solved: converting spreadsheet (.wks) to excel 07

Is this of help ??? http://forums.techguy.org/business-applications/779694-solved-works-vs-excel-formats.html

Read other 3 answers

I use Microsoft Excel 2007. I have a block of information that is 13 rows long (with numerous blocks of information) and would like to convert each individual block of 13 rows to 13 columns (with each row being one of the blocks of information.) Cutting and pasting would take forever and I'm sure there's a faster way to do it. Help!

A:Excel Spreadsheet help converting blocks of information in a row to columns

Read other 11 answers

I have uploaded a sample of the spreadsheet I am trying to modify and I kinda have it working the way I want and I need these costs broken out the way I have them. I will try to explain what I want the best I can so bear with me.

I want "Total" to capture if it is an expense or income. (right now it is not)

I want "Balance" to reflect if it is an expense or income. (right now it is not)

I want any unpopulated cells to show nothing or ""

This is probably simple for an excel wizard but I only know excel good enough to get into trouble!

Any help is appreciated, thanks, Joe

A:Solved: Can someone help me with this Excel spreadsheet?

Read other 16 answers

Every month for several years I have accessed my own spreadsheet offline from desktop icon.
To utter consternation and increasing frustration, today OPEN brought up the file BUT can do nothing with it.
Same results with backups on different drives.

Consequently told browse to find program from which can OPEN. Obvious choice MSN Excel. Result: "Cannot find any version ...to open file for edit".

Further on I installed msn xlviewer. In Open process came box, "Office Source Engine (Process ID: 2120) running. Need to Close". How/where to do so no idea. I am on Vista Ultimate with !E7; note not included in list for this item.

FYI, I only have Office 2002 (with Excel 2002), but cannot even remember last time I used it for anything. Also note many MSN references to Office 2003, but hardly ever 2002.
Only secondarily (and reluctantly) interested in making Excel function to restore ability to use my spreadsheet.

I will be most grateful for help in this unexpected problem.

A:Solved: Spreadsheet with/without MSN Excel

Read other 16 answers

I have a spreadsheet that I need to sort by column (P) which has formulas in it that added data from each row across. I checked all my formulas and they are correct. I had to delete 3 separate rows so I highlighted each one and went to "insert/delete rows, columns" etc. and deleted them there. I then went to DATA and sorted by column (P) from highest value to lowest value and that computed correctly. The data in each row however shifted so each row is incorrect. I don't know how to fix this. Can someone PLEASE help!! This is the only spreadsheet I work with and have never had a problem. I know I must've done something wrong but I've been working on this for 2 days. Did I mention I hate excel due to my ignorance of how it works??? HELP!! Thanks in advance.

A:Solved: Excel Spreadsheet HELP!!

Read other 13 answers

Hi everyone! I'm trying to set up a spreadsheet for my husband who is a competitive swim coach.

He needs to be able to look at it and see if he tells the kids to swim 10 one minute sets, how many minutes that will take. (Gets more complicated than that of course! ) So I set up a spreadsheet with the seconds across the top and the number of sets along the side and did a formula series in the time increments. i.e.: :25, :50, etc...

The problem is when it gets to 25 seconds x's 3 -- it needs to read 1:15 - and all I can get is :75. It needs to be on minutes and seconds like a clock.

Anyone know how I can get it to read correctly??



A:Solved: Excel Spreadsheet

enter seconds in a cell as:



then right click the cells and click Format Cells, select Custom and enter mm:ss to just show minutes and seconds

is this what you meant?

Read other 2 answers


After a power outage a particularly important file gets the error "Excel cannot open the file.xlsx beacause the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file. The file format has not changed. Is there a safe free program that can uncorrupt a file? I have tried Open and repair, changing the format, and using open office. Also tried using recova but the file was not lost.

A:Solved: Excel 2007 spreadsheet gets error "Excel cannot open the file .xlsx.." How ca


and 5 ways are shown here http://www.wikihow.com/Recover-a-Corrupt-Excel-File

Read other 2 answers

I am trying to enter a whole number that looks like this "123" into a cell and have it look like this "00123". I've even tried to custom format it and I can't get it to work. Please help

A:Solved: Need help formatting Excel spreadsheet

Hello smeegle, select the cells that you want to format and the on the main menu select Format>Cells>Number>Custom
and type in the box
this will give you the format that you have shown.

Read other 2 answers


I am having a hard time getting my formula right to automatically work out what percentage will be earned on sales, which is dependant on what percentage of their annual target has been reached.

I have got the formula to work for one of the commission rates but my maths or formula isn't working on any of the other rates.... Could someone please have a look at my attached spreadsheet and correct the formula!

Very much appreciate your time


A:Solved: Excel Spreadsheet - Commissions

Never Mind, I figured it out myself!!!

Read other 1 answers


I am using a code to compare two spreadsheet.
One of the function is to copy the modified records in a different worksheet, highlighting changes element in red.
The script works, but ONLY when the cell is modified to "blank"(no value), I get coloured in red the upper cell instead of the correct one.

Here the script, any help?

Sub GDV()
Dim WsA As Worksheet, WsB As Worksheet, WsC As Worksheet, WsD As Worksheet, WsE As Worksheet
Dim rFind As Range, c As Range
Dim I As Integer, ColCnt As Integer

Set WsA = Worksheets("OldExport")
Set WsB = Worksheets("NewExport")
Set WsC = Worksheets("Changes")
Set WsD = Worksheets("PosDeleted")
Set WsE = Worksheets("PosAdded")

ColCnt = WsA.Cells(1, Columns.Count).End(xlToLeft).Column

With CreateObject("Scripting.Dictionary")
For Each c In WsA.Range("A2", WsA.Range("A" & Rows.Count).End(xlUp))
If Not .exists(c.Value) Then
.Add c.Value, False
Set rFind = WsB.Columns(1).Find(What:=c.Value, LookIn:=xlValues)
If Not rFind Is Nothing Then
For I = 1 To ColCnt
If Not c.Offset(, I - 1) = WsB.Cells(rFind.Row, I) Then
If .Item(c.Value) = False Then
rFind.Resize(1, ColCnt).Copy WsC.Range("A" & Rows.Count).End(xlUp).Offset(1)
.Item(c.Value) = True
End If
WsC.Cells(Rows.Count, I).End(xlUp).Interior.ColorIndex = 3
End If
Next I
MsgBox c.Value & " PosID has been canceled!"
c.Resize(1, ColCnt).Copy WsD.Range("A" &am... Read more

A:Solved: Excel VBA comparing spreadsheet

to who may be interested
I found a solution (workaround) here:

Read other 3 answers

I have a large spreadsheet in which data is added weekly. At the top of the page I have several "windows" in a set of frozen rows which display results from the various columns. I would like to know if it is possible to have a function in a cell which would make a calculation using the last added row of data. For example, to compare a price to the previous week or to the highest figure in the column.



A:Solved: Excel 2003 spreadsheet

Read other 10 answers

We are playing a silly game that is teaching me about trading on the Stock Market. I am trying to figure out how to work my spreadsheet up so that it will tell me when to buy and when to sell my stocks in certain companies. I have the basic spreadsheet with category, business, bought, sold, buy, sell but I am having a problem. I need a column to automatically tell me the lowest amount seen in "buy" and the highest amount seen in "sell". Is there a way to do this? I used to think I was proficient in Excel but this gives new meaning to "tearing your hair out" for me. I'm sure that there are pivot tables and all sorts of other things to utilize but I'm not sure how when I'm only wanting to see things a certain way. Can you help?

A:Solved: Excel Help with trading spreadsheet

Read other 11 answers

Just got this after downloading google drive. I am new to excel. I enter a number in a cell and goes in. My question is this. How do you move that number say to the centre of the cell? Thanks

A:Solved: google excel spreadsheet

Click the Horizontal icon then select Center:

Read other 3 answers

I have an Excel spreadsheet, shared over the network and anytime I try to make and save changes over the network, it tells me that the spreadsheet is read only.

I've checked the attributes of the folder, and the file itself, and it does not indicate that it is read only

I'm using Office 2007 Ultimate and Windows Vista on the machine I'm doing the editing on, and Office 2003 and Windows XP Home on the laptop where the share folder/file resides, if that makes a difference.

I've also checked permissions, and it's checked for Unrestricted Access

A:Solved: Excel spreadsheet says that it is read only

Read other 15 answers

I have a data base that is linked to an excel spreadsheet. I want to be able to open that sheet up by pushing a button on a menu form in access.

Currently I have a button that opens up the application but then I have to open the excel file after excel opens.

How can I get the file Quick Guide.xls to open right up by pressing a button on the access menu?

A:Solved: Access - Open Excel Spreadsheet

Read other 6 answers

I was given a password for a locked Excel spreadsheet, but when I go to TOOLS>PROTECTION the "Unprotect Sheet" option is greyed out so I can't even get to a point where I can enter the password. Is there anything I can do to get around this?


A:Solved: Unlocking Spreadsheet in Excel 2003

Never mind. I realized that I had to have sharing turned off before I could unprotect it.

Read other 2 answers

I have raised an Excel 2003 spreadsheet and wanted to show grid lines in it. I have followed the routine "Tools/Options/View" and made sure the grid lines box is checked, but when I print the document none are showing. Can anyone suggest how I can correct his please?

A:Solved: Gridlines do not show in Excel spreadsheet

Read other 9 answers

I have a spreadsheet with almost 3,000 lines in it that I'd like to add to a Dashboard in Excel - but I can't figure out how to do this within excel.

I know how to embed a spreadsheet from excel into a word document, HTML document, etc - but not within the same program.

I want a dashboard "rectangle" that is scrollable within itself to show all 3,000 lines of data without taking up more than 30 standard-sized rows.

This is an Asset Management spreadsheet with several dashboard items as pie charts, graphs, etc - but I'd also like all of the PC names listed on the same page without taking up all the space it normally would - it needs to be the same size as the other graphs.

Any help is appreciated! Thank you!!


A:Solved: Embed a Spreadsheet in Excel (Dashboard)?

Read other 10 answers

I am thanking everyone in advance for their help. I've been trying to figure this out forever and I'm sure there is a way (I hope).

Attached is a photo of what I am trying to work on. I'm trying to keep stats of all of mine and my friends gears of war 2 games.

Gametype is either Execution or Warzone.
Map is the map played that game.
Win/Loss was if we won or loss.
Columns E-K have three numbers #/#/# The first number is how many kills the person got, the second number is how many times the person died and the third is what place the took on the team (1st-5th).

To make this easier, I will be basing the equation on my stats (I DontHate I, Column E)

Here is the first equation I'm trying to figure out:
IF the gametype is Execution(A) then I want the results of E to go to M2
IF the gametype is Warzone(A) then I want the results of E to go to M3
This is the equation I'm trying to figure out for column E is as follows:

I want the results of E to show up in M2 or M3 depending on the above IF equation. I want the sum of all the Execution Kill/Deaths to be put in M2 (based on spreadsheet right now that would be 21/10) I want the sum of all the Warzone Kill/Deaths to be put in M3 (24/10). I then want M2 and M3 added together and the results to be put in M4(I know this one is simple, just trying to explain EXACTLY what I'm trying to accomplish)
If there is a Null listed, that means the person didn't play and I want the equation to ignore that ... Read more

A:Solved: Need help with a couple MS Excel Spreadsheet equations.

Read other 16 answers

I have an Excel spreadsheet split into two ranges. I accidentally sorted only one range when I thought I was sorting the whole spreadsheet, then made other changes and saved the file. I could not undo back far enough. Is there anyway to re-sort so I can re-connect the two ranges and put them in the correct order?

A:Solved: Excel Spreadsheet Accidentally Mis-sorted

Hi, this is something that is 'back to the drawing board'
There is no way that Excel knows what the previous sorting was.
Your only option is to lookup the file using Windows Explorer, righclick on the file and if you're using Windows 7 or later there is a tab named 'Previous Versions' you can then see if you can find a file before you carried this out and recover it.

Good luck

Read other 2 answers

whenever I try to send a spreadsheet using th "send to > mail recipient" excel freezes up?

A:Solved: Excel freezes up when trying to send a spreadsheet

How about other programs? Does Word do the same thing? What is your email client? Do you have any add-ins installed? Try opening Excel in safe mode (using the switch "/safe" from the run prompt: hit the flying windows button, click Run, type "excel.exe /safe") and trying it.

Read other 1 answers

I have a spreadsheet which contains entries in one particular column than need to be replaced and I am looking for a way to automate this task. In the column there are 4-digit numbers starting with "0001" on up. Each number stands for a given department, but the reader of the document would like to see the department name listed as well. So in other words, I need to replace "0001" with "0001 - Dept A," "0002" with "0002 - Dept B" and so forth.

I was going to build a macro for one replacement, then edit the corresponding VBA code to automate the rest of the list. The problem seems to be the leading zeroes!!! I can search for "0123" but I cannot search and replace for "0123" because then Excel finds nothing to replace. It will execute a search and replace for the string "123" but of course that is useless.

I tried reformatting the cells but that does not work. The original cells still carry the leading zero but the replace request still turns up nothing. Anyway, I do not really want to reformat anything, just replace.

This looked so simple at first. I am not a VBA guru by any means and I need to get this done as I learn. Could someone suggest some VBA code that would do this directly without building on a macro?

A:Solved: Replacing data in an Excel spreadsheet

Read other 16 answers

I have an excel spreadsheet I am entering data in on a monthly basis. I have to add names in the "A" column and then numbers in subsequent columns. I hope that makes sense as I know NOTHING about Excel except to enter data and maybe a SUM formula here & there. SO... I'm adding the new names and I get to line 97 and NOTHING goes into the field. It shows on top in the formula bar but that's it. My husband needs this info for a meeting tomorrow. Can anyone help...PLEASE??!!!

Thanks in advance

A:Solved: Excel Spreadsheet Help needed ASAP

Read other 12 answers

Greetings forum,

I have an Access database main table that I try to update at least monthly with an Excel spreadsheet feed. The spreadsheet formatting is always the same, with occasional additions or deletions of rows...those changes are what I am trying to update the database with. The rows represent personnel and their personal information. People come and go...blah, blah, blah.

The problem is when I run the new reports and save them in Excel. I save them in the same place and rewrite over the old file with the same file name. Then I try to import external data into the Access database using this overwritten file as an append query. It worked the first time I set it up, but when I try to use it again as a saved import, I get an invalid file name for the overwritten file. Microsoft appears to be adding a hidden appendage to the file name when I overwrite the original file.

Has anyone had experience with this problem before?

A:Solved: Importing Excel spreadsheet into Access problem

I haven't heard of this problem.
Perhaps you could tackle it differently. I normally just import the file to a temporary table (which requires no save import) and then use an Append query to add the records to the table and then a delete query to clear the temporary table.

Read other 3 answers

Hi everyone, I was having some trouble with the format of the date in my excel document.

Basically what i want to do is type in for example todays date (Aug 18), and then when clicking below onto the next row, I would like to see the date come up above as (08/18/2005).

Instead the problem im getting is the date comes up as (08/18/2018)????

Ive tried right-clicking the entire column, where the date is being entered, and using "Format Cells" to set the appropriate date format. I have also verifed the date is set at 2005, so far nothing works.

I welcome any ideas/suggestions???

Thanx everyone

A:Solved: Trouble formatting date in excel spreadsheet

Read other 10 answers

Hi all,
being a non-techie I apologize in advance for any ignorance I display
I searched the forums and found a similar question dating from 2005 but not a real solution. So here it goes:
The aim of the exercise is to divide the data from within an excel spreadsheet into many spreadsheets, each of which needs to be sent by email to different participants.

The background is as follows: the big spreadsheet is delivered to me by a statistical department that makes a selection of households to take part in a survey. These households are coming from all over the country and are identified by a three digit number (Column U). Next to the households there is the interviewer and his or her email address . The excel file is already ordered on the interviewers (Columns R and S).
Is there a way to automate this process?
A sample zip file with the spreadsheet to be divided is included
Thanks for any help.

A:Solved: How to divide an excel spreadsheet into multiple spreadsheets

Read other 16 answers

I recently set-up one of my first spreadsheets and when I need to print it doesn't the gridlines. I trhink I have the print setup set for printing guidelines, yet when I do the print preview it only shows the numbers in the columns without the gridlines.
Thank you for any help.

A:Solved: MS Excel & printing spreadsheet grid lines.


The directions may be a little different depending on which Outlook version you have but in Outlook 2007's Print Preview window, click the Page Setup button and go to the Sheet tab.

Make sure the Gridlines box is checked here.

Read other 3 answers

Does anyone know how to open an Excel 2007 spreadsheet with OpenOffice? The file's extension is .xlsx
I did right click on the file and then click open with OpenOffice. At that stage it gives me a huge list of names to click to open and I am unsure which one to choose. Thanks for the help.

A:Solved: Excel 2007 spreadsheet how to open with OpenOffice?

Do you have any version(s) of Excel? If so, get this.

Failing that, you could open in Excel Viewer, then copy the data & paste to Calc.

I also found this -- although can't vouch for it personally.


Read other 2 answers


I have Excel 2003 SP2 on a users XP SP1 PC. When they have a few spreadsheets open they appear on the taskbar but when they try to tab between them or maximise them nothing happens. They can open the spreadsheets by going into the current one and selecting Windows and selecting the one they want.

There are always another number of applications running on the PC at the time but they can tab fine through them it just seems to be excel related.

thanks in advance for any assistance,

A:Solved: Unable to maximise excel spreadsheet from the taskbar

Quite odd - they appear on the taskbar but nothing happens when they click on them? Or do they not appear on the taskbar? The latter is an easy fix, go to Tools, Options, View, Show Windows in Taskbar.

Read other 2 answers

Hello all,

I don't know if I'm posting in the right forum. This is an Excel problem I'm having at work.

I'm not overly Excel savvy, but I know enough to get by at work, and fix most problems myself.

I may just have some post maternity baby brain, but I can't fix this problem.

My manager has a spreadsheet with about 5 tables in, each with monthly totals for different areas, and each cell pulls data from half a dozen different spreadsheets and work books. Pulling cell refs from so many things makes it slow on opening, and management asked me to find a way to have individual months formulas calculate on the click of a button, rather than on opening the spreadsheet.

I did a little test sheet which worked fine, but when I did the same on managements spreadsheet it went a bit pete tong. I recorded a macro to input the formula, which when I recorded it, is fine - all totals are correct, but when I run the macro only half the formula appears.

I even tried a different method; taking out =sum, so the formula doesnt work on opening and having a macro that simply pops that bit back in, but half the formula disappears when I run it, even though the macro doesn't touch the rest of the formula.

Any clue as to why this happens, or am I just being a ditz and over complicating things?

Sorry if this is a bit confusing - I'm not great with excel, and I'm now at home without the spreadsheet so can't go into much detail.

Ta muchly.

A:Solved: Excel Spreadsheet macro/formula query

Read other 6 answers

I am pretty good with most commonly used Excel functions but this is one I can't get. Please help!!!!!

I would like to re-format the way the spreadsheet is set up on sheet 1 to look like it is on sheet 2. I would like all contacts to have all of their info read left to right starting in column A and the move across to the right. So in the end all Business names would be listed in column A and then all owners would be listed in column B. The only way I can figure to do this is to copy and paste each individual customers information.

Maybe there is some sort of formula to build to make things read the way I want? Or I am just not coping and pasting correctly?

Please help!!!!!

A:Solved: Switching Axis in a poorly setup Excel Spreadsheet

Read other 7 answers

Hi All

I have a spreadsheet full of numbers formatted as currency. Some dollar amounts are positive and some are negative. I want all the negative numbers to be in red font. Instead of me searching for all the negative numbers (they are in the hundreds) and turning them all red manually, is there a simple macro that can do the trick? This will save me a lot of time. Since the numbers change from negative to positive and vice versa and the number of rows and columns also change, I'm having a hard time programming it.

Has anyone out there written a macro than can do this?



A:Solved: Turning negative numbers to red font in an Excel spreadsheet

It's built into Excel - just highlight the cells, go to format cells.
Go to Currency. There are 2 boxes on the right - the lower one allows you to have negative numbers in parentheses ($3.00) or red $3.00 or a combination of those two or with a minus sign.

Read other 3 answers

Running WinXP and Office 2003

Hello. This is similar to http://forums.techguy.org/business-applications/257309-exporting-word-form-data-excel.html

I tried using and tweaking that example but am having a hard time because there are several different things.

I will be having hundreds of word documents. The first page on each doc is just a form that a user fills out on the computer. I would like some help with the macro that would run and process a folder of these docs.

I would also like to have 3 sheets in the one excel file. The doc file will be filled out generally by 3 departments. Is there a way to have a drop menu in the doc to indicate which dept and also have this transfer to their respective sheets in the excel file? The rest of the doc fields should be the same. Also I need the hyperlink to the file in their respective cell.

Sorry I am new to code in excel and am starting to learn its power. Thanks for your help!

A:Solved: Exporting Word Form Data to Excel Spreadsheet

Read other 16 answers

Hey everyone,

I'm trying to stretch my resources and minimize some data entry, using the tools at hand. However, I've hit a bit of a wall on inspiration - looking for some ideas.

I have an Excel Spreadsheet (about 8 worksheets) that I use to log some daily activities - however, because I have a lousy memory, I like to email myself from the road with the notes for my Log. Then, when I return to the office, I either re-type (or copy/paste) my email notes into the appropriate sections of my log file.

What I'd LIKE to do is create a form and rule in Outlook that would auto-fill my Excel worksheets based on the text of my email. I'm not worried about Triggers (the rules setup on that end is simple enough for me), I'm more looking for the best way to have Outlook interact with Excel in this way.

I send emails from the road on my Android phone.

Any ideas? Thanks!

A:Solved: Outlook Email to Auto-Fill Excel spreadsheet

Read other 8 answers

Hi, I have Windows 7, Excel 2007. I'm printing an existing table. When I "print preview", it shows like it's supposed to, but when I print it out on my network printer, HP Laserjet 3390, the header & header title rows are not lined up & print weird. However, when I print them on the HP Officejet J5750, it prints out exactly as in "print preview". I've attached a word doc that shows both versions (I hope it's attached). Ideas anyone?

A:Solved: Excel 2007 spreadsheet doesn't print as viewed

Read other 16 answers

I am usually savvy about Windows, but this one has me stumped. I have taken on a volunteer project that requires me to add volunteer hours in an Excel Pivot Table. I am having calculation issues which I believe to be caused by a limit on the maximun number of rows. Reading Excel help is just confusing me more. My mentor showed me how to do this once, but I did not take notes and now I am a lost puppy. Given the above information, does anyone have a solution? Thanks for your time.

A:Solved: Excel 2003 help, Edit number of rows in a spreadsheet

Read other 7 answers

I am fairly new to VBA and this is my first post so please be patient with me. I require the assistance of other vba programmers in coding the following:

1. The user selects a Report ID from the first List box "Report ID's", clicks the "Add Single" button, then clicks the "Print Report" button. - (I have coded this)

2. The code for the print report button needs to take the report id from the "print report" List box and looks in the "Report ID" column from the "Reports" sheet for a match. Once found, it grabs the corresponding compilation no. for that Report ID.

3. It then uses that compilation ID no. to search in the "Compilations" worksheet for a match; it then grabs the corresponding Keyword for that compilation ID/no.
4. Lastly it uses the keyword to search for a match in both "Keywords1" and "Keywords2" columns from the "Exhibits" worksheet. Once a match has been found in any of the columns, it then grabs that entire row/exhibit and prints it out in it out in a word document, with correct formatting, Labels and headings, for the user to edit.

I would appreciate any assistance that can be given and strongly emphasise that i am not looking for someone to code everything for me, instead to take patience and go through a process step by step if possible.

Thankyou to any users who provide assistance, your patience and time taken to help has been duely noted and much ap... Read more

A:Solved: Create a report in word based on excel spreadsheet data

Read other 16 answers

I need to write a macro that will copy data from one spreadsheet into a separate spreadsheet (not in the same file). Here is the scenario...

On the first spreadsheet I have a customer's name in one column and a customer's address in another column. On a separate spreadsheet a have those same customer's names without the addresses. On the second spreadsheet the customer's name may be listed more than once. What I need to do is add the corresponding address to the second spreadsheet beside the name of the customer (identical data from both spreadsheets). The reason copy and paste won't work is because the customer may appear numerous times on the second spreadsheet and their are approximately 50,000 rows of data.

The macro needs to basically say IF Spreadsheet 1, Column A (customer) equals Spreadsheet 2, Column G (customer) then ADD/REPLACE info from Spreadsheet 1, Column B (address) to Spreadsheet 2, Column H (currently blank). I just can't figure out how to make it do that. ANY HELP ANYONE CAN GIVE IS APPRECIATED!

A:Solved: Need Help Writing a Macro for Excel to Move Data From One Spreadsheet to Anot

Read other 7 answers


Im quite new to this excel programming thing and could really do with some help.

I need to send an automated email to 3 recipients (always the same 3 email addresses) when a number (formatted from a countdown of days to go) is 10 or less. Also i need a different automated email to be sent when a date is manually entered into a different cell.

I have managed to get the current date and time on my spreadsheet and used the format to work out the days to go to the deadline.

I have looked over all different types of forums but unfortunately because i'm still very green when it comes to excel i get lost and confused when trying to do this.

Is there anyone out there who can treat me as an alien and help me through this step by step.???

A:Solved: Send an automated email (outlook) from Excel spreadsheet dependent upon comle

Read other 10 answers


I have several completed templates that I need to summarize into a spreadsheet.

Is there a way for me to list down the files and the location of the excel spreadsheets and run a macro for copying the data I need from the files listed and pasting them into a spreadsheet format?

Here's what I am doing now, manually.

1. Open file1
2. Copy B2
3. Paste to SummaryFile on B1
4. Copy C2
5. Paste to SummaryFile on B2
6. Copy D2
7. Paste to SummaryFile on B3
8. Close file1

9. Open file2
10. Copy B2
11. Paste to SummaryFile on C1
12. Copy C2
13. Paste to SummaryFile on C2
14. Copy D2
15. Paste to SummaryFile on C3
16. Close file 2

I hope somebody can help.


A:Solved: Excel Macro needed for creating a spreadsheet from data on several but similar files.

Read other 7 answers


I've been using this site in the past while looking for fixes to various problems, recently registered and tried to help a little in my free time but now I am facing rather a big problem with which I am not sure what to do.

Please excuse me if you will deem it as a waste of time as I found few general ideas on how to go about fixing it:
http://forums.techguy.org/business-applications/1007467-excel-2003-wont-open-some.html post #9

I am posting as I'm not sure that those fixes will work and I have 4 users from Finance Departament at a finance year end who desperately need to fix the problem.
What happens is, they have have a spreadsheet (.xls) on a shared network drive which is crashing upon opening if sharing is turned on. If sharing is disabled one person can work on a document.
2 users have Office 2007, other 2 use Office 2003. 3 of them are facing this problem, one with 2007 and two with 2003.

I am really clueless and would appreciate any troubleshooting ideas and/or potential fixes.
For the time being I'm off to remove KB2502786 and kb2541025 updates from user's machines (I they are on) and will post results. Hopefully I will get some replies in the meantime

Thanks for all the help in advance

Just checked with one affected user who is using Office 2007. KB2502786 and kb2... Read more

A:Solved: Excel 2003 spreadsheet crashes when opened from network location with sharing

Read other 9 answers

I am currently working on a spreadsheet for a complex budget, and the spreadsheet is constantly expanding by way of additional columns (a new column for each day).

At the end of the columns that represent each day, there are five columns that show calculations based on the entries in the columns that are before them. One of those columns calculates the average of every entry in that row. In the sixth column, we want to be able to calculate the average of the last four day entries without having to manually adjust the range each time we expand the spreadsheet.

That's probably not particularly clear, so in summary, we have a column for every day of the last twelve months. Each cell shows a dollar amount. At the end of each row, we have five columns that display various calculations for each row. At the end of those calculations, we want a further calculation that will show us only the previous four days.

Needless to say, every time we add a column for a new day, the range (showing the average of the previous four days) expands to show the average for the last five days. Rather than this happening, we need the range to move forward, rather than expanding, essentially following the cell at the end of the row that shows the average of those four days.

In essence, we need a cell to calculate the average of four cells that are five cells behind it, without ever expanding its field of reference.

Apologies if this description isn't particularly helpful...it's a dif... Read more

A:Solved: Relative Cell Ranges In An Expanding Spreadsheet (Microsoft Office Excel)

Read other 8 answers


I have an old Quattro Pro file which I would like to access but do not have Quattro Pro installed any longer. I believe it may be possible to open in Excel. When I opened Excel and click on Open, File Types, I tried Quattro Pro/DOS types but that (and any other trial I've had) returns a warning message ".wb3: file format is not valid". The file had been on a 3.5" floppy and maybe (hopefully not) the floppy is unreadable.

My OS is Windows XP and I have Excel 2003.

Thanks for your time


A:Solved: Converting .wb3 files to Excel

Welcome to the board.

Try this?

Read other 2 answers

I am trying to open a spreadsheet that was created in Excel 97 using Excel 2000. The links and macros that are on the sheet seem to prevent it from opening. There are a load of error messages but I just cannot get the thing open. I have searched so many places, found the same problem but no answer.

Can anyone help?


A:Excel 2000 problem when opening Excel 97 spreadsheet with links and macros

Welcome to TSG.
Can this file be opened fine in Excel 97? Any chance that it is corrupted?
What are some of the error messages you are getting?


Read other 3 answers

I am trying to export data from word or excel form into a spreadsheet. I have tried the macro at http://forums.techguy.org/business-applications/257309-exporting-word-form-data-excel.html and it worked for all text fields but not the drop down list options that I have in my form. Can anyone please help/

I have never done this before, hence the struggle. Any help would be much appreciated.

I attach the word form and the excel form which also includes the excel spreadsheet that will collate the data for analysis.

I would prefer the form in word and have it set up as that indicated in the forum thread above but picking up the data from the drop down lists as well.


A:Export data from word or excel into Excel spreadsheet

Hi there, welcome to the forum.
It seems this post you added on August 12th hasn't given you much answers.
You mention the two files, OK, But what I don't understand
I am trying to export data from word or excel form into a spreadsheet. ...
Click to expand...

You probably forgot to attach the macro's with it, that is if you did anything with the link you mentioned.
If you could attach the files with the macros, I could take a look and see what I can do for you.

Another thinng From Word or Excel.

Which one is it going to be?

Read other 1 answers

I'm trying to Merge an Excel spreadsheet to Outlook and provide alerts for critical dates in said spreadsheet in the Outlook calender !

A:Excel - Merge Excel spreadsheet to Outlook with Alerts

Welcome to TSG faithtronic.

I've never done it but your thread has been setting here a while. A method to do this here http://www.ehow.com/how_5685419_create-calendar-excel-data.html

I would start with a couple of dates so not to screw up the whole calender! There are some sharper excel folk on this site that might provide a better answer. But this is a starting point?

Read other 1 answers