Moving data using macros

[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

 

[Don Guillett]

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

 

[out of my depth]

Thanks very much Don

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)