Forum Discussion
Auto-populate sheet 2 when updates are made in sheet 1
I have followings Tabs in my workbook (Apple, Orange, Cherry, Fruits) Apple, Orange and Cherry has following columns (Date-D, CustomerName-N, Count-C, PricePerCount - P, TotalPrice- T) , total pric...
Thanks Subodh for your quick reply.
This is what I was looking for.
Sorry for confusion regarding the column headers. Name(N) was not column N but just to represent a variable for name .
There is some slight change in the file (please see attached) . I have sales and purchases in same workbook.
The tabs are S-Apples, S-Orange, S-Cherry and S-Fruits for sales
There are tabs P-Apples, P-Orange, P-Cherry and P-Fruits for purchases.
The requirement is that sales of individual fruits get consolidated in S-Fruits and similarly Purchases of Individual fruits gets consolidated in P-Fruits
Can you help me with this
Make sure that all your S tabs and P tabs have a similar layout.
Please check the attached with the tweaked code in place.