Re: Taking info from all sheets and compiling it without spaces

Tech-Archive recommends: Fix windows errors by optimizing your registry

Now we're getting somewhere. There is one sticking point. In the Master
***, it would sure be helpful if there was something, maybe in Column A,
to show where A's clients end and B's clients begin. I understand that
place is not fixed and must move as clients come and go, that's OK. The
problem I see is that when the code goes to copy/paste A's or B's or C's or
whoever's clients, it has to find the beginning and the end of those clients
as they exist on the current Master ***. Then the code can move things as
necessary to create the space necessary to paste the list of clients.
I envision something like this:
A's name would be in A1.
A's clients would start in row 1 in Column B, C, D, whatever columns are
necessary for the client data.
A's clients go to, say, row 100.
Maybe have a blank row to separate things. This is not necessary for the
code. Just a suggestion.
B's name would be in A102.
B's clients would start in row 102 in Column B.
And so on.
This is your business so get it the way you like it, but the code does have
to have a way to find A's clients, B's clients, and so forth.
How many columns go with each client?
Do you have any headers in any of the sheets?
Otto
"ZBelden" <ZBelden@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D160D9BA-4F53-4BEE-876E-730EFC0A0D3C@xxxxxxxxxxxxxxxx
Sorry I really don't know much about macros which is making explaining
this
hard... What I am doing exactly is taking the client lists of all my
co-workers and compiling them into one master ***. The reason I need
macros
is because I want this document to be present on everyone's computer so
when
I edit in the additional information on the individual sheets, they will
be
able to look at the master *** and see all the information easily by
just
updating it. Here is a step by step example of what I want done: I have
two
people working for me, worker 'A' and 'B'. Worker A has 100 clients and B
has
200 clients. On A's individual client ***, his client information covers
the cells A1:H100. And on B's individual client *** he will cover
A1:H200
(same information across the columns). On the master ***, I want A and B's
clients to 'stack down' so to speak. As in, A's clients will be first and
fill the cells A1:H100 and B's clients will cover A101:H300. If I were to
ADD
a client (new row) to A's list, nothing would be updated on the master
list
because that extra row would not be included in the range taken. So then I
would want the macro to be able to expand A's range to cover that extra
row
and move everything down after it. The ranges for the two workers on the
master *** would then be A: A1:H101 and B: A102:H301. So at that point,
everyone that works for me would be able to see an updated list they could
reference and not take eachothers clients etc. Thanks so much for reading
this far, help is really appretiated!

"ZBelden" wrote:

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 work***. 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 *** (by pressing a button of some sort). I know how
to
tell a macro to take a designated range from one *** 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 ***
and
I dont' want to have to constantly update ranges in the macro. Any and
all
help is greatly appretiated, thanks!


.

Quantcast