I have a number of tabs in a worksheet. I want to create the data in a new tab on the same worksheet based on the data that is entered in the other tabs.
Column A Column B Column C Column D
R1 Expense A 50.00 25.00 6/8/4
R2 Expense B 60.00 35.00 3/8/4
R3 Expense A 50.00 130.00 9/8/4
R4 Expense C 120.00 25.30 4/8/4
I would now like to create more tabs, called Expense A, Expense B, etc and bring in the data from the other tabs based on the 'Expense' cell.
Hope this makes sense!