Moving data using macros

  • Thread starter Thread starter out of my depth
  • Start date Start date
O

out of my depth

Hi All

I am attempting to compile a number of lists from a daily report I get.
What I would ideally like is just to cut the page into excel, run one macro
and all the relevant lists be put on seperate pages.

The question I have is how do you get a macro to look for the first
available blank rom. i.e. How do you tell the macro to put the data
underneath the one it did yesterday (if that makes any sense!).

thanks very much!
Tom
 
1. NextRow=cells(rows.count,"a").end(xlup).row+1
2. Different ways depending on your layout.
 
Thanks very much Don

Don Guillett said:
1. NextRow=cells(rows.count,"a").end(xlup).row+1
2. Different ways depending on your layout.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
Click to expand...
 
Back
Top