What I would like is to have a single button that when clicked will find the
next empty cell on a separate worksheet then paste a block of information
that spans several rows/cols. I already have the formulas and macros to pull
the information I need into a third sheet so that it is formatted properly
for printing/veiwing.

I am not very literate with vb as most of my experience is from seeing
something that looks like it will work for me and then playing with it until
I get the results I need.

Any help is appreciated

As always post YOUR efforts for comments

lastrow=cells(rows.count,"a").end(xlup).row

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Wundrfulthing" wrote in message
...
What I would like is to have a single button that when clicked will find
the
next empty cell on a separate worksheet then paste a block of information
that spans several rows/cols. I already have the formulas and macros to
pull
the information I need into a third sheet so that it is formatted properly
for printing/veiwing.

I am not very literate with vb as most of my experience is from seeing
something that looks like it will work for me and then playing with it
until
I get the results I need.

Any help is appreciated