Posting data from one worksheet to another.

jjackson

New Member
Joined
Nov 21, 2005
Messages
28
Hi,
I am trying to add data from one worksheet to another automatically. When I type in data from worksheet a and worksheet b and it automatically transfers to worksheet c.
Here is the problem sometimes the data from worksheet a is different and uses more cells and the same for worksheet b. Is there a way so that the data transfers from a and b to worksheet c can be filtered so that I dont have to create a static formula in worksheet c thus leaving unused cells in my worksheet c?
Thanks in advance for your help.
 

acw

MrExcel MVP
Joined
Feb 13, 2004
Messages
4,814
Hi

Can you give more detail Is the data from "A" and "B" completely different and should be on its own row, or is the data in some way related and "C" is a combination of both sheets' data?

Some examples may also help.


Tony
 

jjackson

New Member
Joined
Nov 21, 2005
Messages
28
The data from a and b is completely different, and needs to be in its own row on worksheet c. Lets see if I can give you an example.
This is a time sheet layout and I have to record different projects that each person works each day. Sometimes people work 5 different projects sometime only 2 or 3. On their individual time sheets(worksheet a and b) I have to put where they worked and on what project. On worksheet C I have to put the totals, so what I want to do is automatically pull the data from a and b so tha it goes to c with no empty cells between the totals of a and b.
The problem is I have cant do static becouse sometimes I use 5 lines of data sometime only 2 or 3. Does that help any?
 

Forum statistics

Threads
1,077,778
Messages
5,336,248
Members
399,072
Latest member
abublitz

Some videos you may like

This Week's Hot Topics

Top