Do Until Macro

  • Thread starter Thread starter Beep Beep
  • Start date Start date
B

Beep Beep

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.
 
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.
Click to expand...

Dim rStoreNo As Excel.Range

Set rStoreNo = Range("J2:J7000")
rStoreNo.Value = "'0001"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Do Until Macro 6
Macro to Combine Data from Multiple Sheets with Cell References 4
Macro to restore previous content of clipboard 3
Macro help please! 7
How to store values in excel using macro ? 4
Macro to complete Google search based on a cell? 0
Macro to Compile Data from Different Sheets 2
Macro to hide cols 2

Back
Top