Summary: Hi ... I'm not terrific with excel and wonder if anyone can help me. I am using excel 2002. I have many thousands of three-row addresses (a1=Name, a2=...
Summary: How can I convert/transpose contact data from a column to rows. CHANGE FROM... name1 add1 tel1 email1 name2 add2 tel2 email2 name3 add3 tel3 email3 TO...
Summary: I need to do some tricky transposing in Excel. I have 4 columns with many rows of data that looks something like this: DATE NAME ITEM COST 3/1/09 J...
Summary: Perhaps it is different for Excel 2002 but in Excel 97 you are limited to 256 columns and 255 sheets per workbook. So the maximun number of columns in...
Summary: I'm trying to reference a column with a row (i don't want to transpose the data). How can i copy it so that it will copy the next column cell and not...
Summary: Thanks derbydad. FYI: I couldn't get back logged in as "russells" and had to re-register. It must be pretty obvious by now that my VBA knowledge is la...
Summary: Piece of cake... With your address data in A1:A12, your VLOOKUP table_array in C1:C12, put this in B1 and drag it down. It will VLOOKUP the suburb in ...
Summary: I'll assume you actually have a blank row between each block of data. I'll also assume that each name, address and city/state is in it's own cell in C...
Summary: I read the post regarding excel overwriting, but I'm not sure that this addresses my problem. Two people are telling me that when they open an excel ...
Summary: Try this: After saving those changes Then, in a blank document: File Save As Normal.dot Saved in: C:\Documents and Settings\Application Data\Microsof...
Summary: OK, I'm a complete dufus when I comes to computers. I'm running Win 98 on my computer & a friend recently installed Outlook XP on my computer because...
Summary: We recently moved my data to a new hard drive. We were unable to properly use Outlook afterwards, concerning the addressing of emails. We have a reins...
Summary: I will answer my own question for anyone who is interested. There is however a minor problem, that i wonder if someone could help me with. So OK Excel...
Summary: I formatted my system without backing up some data. All I really need is my Corel Address Book 9 (2000) addresses. I ran a data recovery software and ...
Summary: I recently backed up a neighbors entire hard drive by copying the entire contents to a external drive. She did not tell me she used Outlook. Now she ...
Summary: I've just migrated Outlook 2003 (settings, contacts, etc) from one machine to another for one of my clients but all is not quite well. Everything is t...
Summary: Just got a new machine with XP on it. It's networked with my other machines which are running Windows 98se. I did the import feature in Outlook to tra...
Summary: hello in my document (on a visualbasic form) i have a combobox and two label fields, the combobox contains the names of the account managers. is there...
Summary: Hi there, I want to push specific data from a selected contact in Outlook 2003 to a predefined Excel 2003 spreadsheet. The scenario is that I want a n...
Summary: What did you try as far as troubleshooting the code to see why it was giving you the error? If you clicked Debug in the error window it would have hi...
Summary: I am creating a table with laboratory data from groundwater monitoring wells (MW). The data is exported from an Access query into Excel. I currently...
Summary: I have an Excel sheet that has over 1900 addresses in single column. I need them in Excel spread over 3 multiple Columns (Company, Street, City/ST/Zi...