From what you say at first, you want a simple copy of the other sheets
placed in the master sheet. But then you say that you don't want any blank
cells in the master sheet, so that negates the copy idea.
Post back and detail the conditions under which you want things copied.
In other words, when you click on the button you want this and that copied,
but you don't want this, this, this, nor this copied.
Provide a few examples to show the pattern. HTH Otto
"ZBelden" wrote in message
...
I am a macro newbie so bear with me... what I'm trying to do in this macro
is
be able to take all the information in a series of worksheets and compile
it
into one master worksheet. I want to be able to edit and add things to the
individual sheets, and with the help of a macro, be able to automatically
update the master sheet (by pressing a button of some sort). I know how to
tell a macro to take a designated range from one sheet and paste it onto
the
other, but I don't know how to code it to take all the rows and columns
with
values in the cells. I.E. I don't want any blank cells in my master sheet
and
I dont' want to have to constantly update ranges in the macro. Any and all
help is greatly appretiated, thanks!