General
in [Excel]
|
Macro to COPY FORMULA BETWEEN RANGES I have a vlookup under inventory, orders & POs, I need to copy and paste it to the end of that range, then go to the next section and paste. This need to continue through many different ranges, and the number of rows could change. Any ideas. I did name the ranges ie "tissue", and "paper towels", maybe there is ... 13 May 2010 09:23
Copy & paste formula I have created a vlookup in C7, D7 & E7. I need to copy the formula down to the end of that range, skip rows with headings and copy to the next set of blank cells. Paper Products - WASHROOM TISSUE Proteus Open Sales Open Description Inventory Orders P.O.s 11375 RESPONSE 241 1154 1100 11440 RESPONSE 1480... 13 May 2010 09:23
hello everybody.. question about .CSV files.. i have a excel .CSV file that Gmail generated for me with my contacts in.. what i want to do is function that go over all the contacts emails one by one and deletes all missformated addresses that cannot be use to send email for them.. somthing like : if (the cell's text is not an valid email address) { de... 18 May 2010 20:21
form validation determines which sheet to add data Let's say I'm creating a form that a non tech savvy used car dealer uses to enter his newly acquired vehicles to the excel workbook. Each sheet of the workbook is a unique model year of the car. (That would allow him to quickly refer to all vehicles of a given year.) On the input form, I would like validatio... 13 May 2010 09:23
Coma between two e-mails I need to send bulk e-mail, How to insert coma between two e-mails ... 13 May 2010 18:17
Exit to the beginning of For Next loop Hi, For i=1 to 5 if .... then .... .... GO TO THE BEGINNING OF FOR NEXT LOOP end if .... .... next i What should I say to mean "GO TO THE BEGINNING OF FOR NEXT LOOP" above (if I can). Thanks and regards, Cousin Excel ... 13 May 2010 08:17
Refresh of Data Hi, Is anybody know that if there are few users in the server, for examp. user A,B,C and there is a share excel file TESTING.XLS. Three of the users have the different right to the TESTING.XlS file. A & B = Read Only C = Full right of amend,read,save. if A/B open TESTING.XLS file in the first, later C op... 13 May 2010 06:07
Can I make an xls start up in 2003 ever since I've installed 2007, all my files will start up 2007 when I double -click them. Can I set up my machine so that: xlsx will open up 2007 and xls will open up 2003 Thanks M ... 13 May 2010 18:17
Expand/Collapse Grouped Data in Protected Worksheet I'm running on Excel 2007 and I need to enable the end users to expand/collapse columns in a protected sheet Instead of adding VBA language and buttons to run the script backend to ungroup/group columns, is there any other ways in Excel that will facilitate the same process? Any feedback will be greatly app... 13 May 2010 02:54 |