Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do Until Macro
I have over 500 Excel Files that I need to import into Access, however I want
to get them cleaned up first. One of the things I would like to is run is a macro from lets say cell J- 7000 ( this could vary with each individual file) and what I am thinking of is that I would input the store number of like 0001 into this field and then the macro would copy it up until it got to the column header which would say store and then stop. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do Until Macro
On Nov 4, 11:53 am, Beep Beep
wrote: I have over 500 Excel Files that I need to import into Access, however I want to get them cleaned up first. One of the things I would like to is run is a macro from lets say cell J- 7000 ( this could vary with each individual file) and what I am thinking of is that I would input the store number of like 0001 into this field and then the macro would copy it up until it got to the column header which would say store and then stop. Dim rStoreNo As Excel.Range Set rStoreNo = Range("J2:J7000") rStoreNo.Value = "'0001" |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do Until Macro
DBKemp
Perfect - Thanks so much "dbKemp" wrote: On Nov 4, 11:53 am, Beep Beep wrote: I have over 500 Excel Files that I need to import into Access, however I want to get them cleaned up first. One of the things I would like to is run is a macro from lets say cell J- 7000 ( this could vary with each individual file) and what I am thinking of is that I would input the store number of like 0001 into this field and then the macro would copy it up until it got to the column header which would say store and then stop. Dim rStoreNo As Excel.Range Set rStoreNo = Range("J2:J7000") rStoreNo.Value = "'0001" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |