I have a *.xlsx file with three tabs: A,B, & C. A is a summary tab that contains all the entries of tabs B & C. Tabs A,B,&C all contain the same columns just with different data. Is there a way to autopopulate A if a row in B or C is filled in?
I have a *.xlsx file with three tabs: A,B, & C. A is a summary tab that contains all the entries of tabs B & C. Tabs A,B,&C all contain the same columns just with different data. Is there a way to autopopulate A if a row in B or C is filled in?
Do you mean that you want to add them together? If so, you can do this in cell A2 of Sheet A:
=B!A2 + C!A2
or this:
=SUM(B:C!A2)
then copy across and down as required.
Hope this helps.
Pete
No My apologies. I just want all the rows entered in the tabs B,C, etc. to also appear in tab A without having to type them twice. Its not a summation, as much a master tracker.
Well you have not described how your data is laid out, but to get data from cell A2 of sheet B (for example) you would use this formula:
=B!A2
this can be copied across and down as required. Similarly, you would use this formula:
=C!A2
to bring data from cell A2 of sheet C - you might like to put this in cell P2, depending on how much data you have. Again, copy across and down as required.
Hope this helps.
Pete
Not Really I'm just kinda failing at explaining it. Here is a very simplified version of it.
What is there about the data that makes you put them in that order, i.e data1, data2, data3, given that they are from different sheets. Is there some date field, and you want them in chronological order, or are they sorted by some name field, or is there an ID code that determines the order, or some numerical value sorted in descending order?
I think you need to explain your requirements more fully (and I think I need to go to bed, as it is 2:15am here).
Pete
There is nothing specific about the order. I could sort the master data by date. But that is really the only thing
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks