Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Cells from other sheets (Speeding up Process)
I copied a large amount of data from Sheet 1 and transposed it into Sheet 2
so I could create a pivot table. Now I would like to link the similarly valued cells together so that I only have to enter a value once in sheet 1 so that it updates in sheet 2 to link to the pivot table Sheet1ActualSalesWeek1= Sheet2ActualSalesWeek1 etc I can do this manually but it is very long and laborious. Because one sheet is transposed I cannot click and drag and when I attempted a macro I encountered a bug. I would be grateful for any suggestions |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Cells from different sheets | Excel Discussion (Misc queries) | |||
Linking cells between sheets | Excel Worksheet Functions | |||
Linking cells between sheets | Excel Worksheet Functions | |||
Linking cells between sheets | Excel Worksheet Functions | |||
Speeding Saving Process | Excel Discussion (Misc queries) |