S
scottranzal
Trying to accomplish the following:
1 Workbook
Multiple Woksheets
1st worksheet has 4-5 columns of non unique data (many rows)
2nd-nth has many columns and rows
I would like to be able to display these 4-5 columns of data on ever
other worksheet within the workbook - LOCKED, so no user can adjust it
The only sheet that would be able to update the 4-5 columns of origina
data is the 1st. I then need to pass these adjustments to the othe
worksheets, so that each page is in sync.
Wanted to use Pivot table, but....
I need to add data to the rows in additional columns, so a Pivot tabl
update would wipe that out.
Here's an example of the first sheet (source data)
Column A - B - C - D - E
0 1 3 5 14
Q W E R T
the additional sheets must have that data plus...
Column A - B - C - D - E - F - G - H
0 1 3 5 14 Q R 0
Q W E R T A B 5
Can't figure out a way to achieve this, so help would be very muc
appreciated. I've thought about filters, pivots, macros but no on
solution has come to mind.
thanks
scot
1 Workbook
Multiple Woksheets
1st worksheet has 4-5 columns of non unique data (many rows)
2nd-nth has many columns and rows
I would like to be able to display these 4-5 columns of data on ever
other worksheet within the workbook - LOCKED, so no user can adjust it
The only sheet that would be able to update the 4-5 columns of origina
data is the 1st. I then need to pass these adjustments to the othe
worksheets, so that each page is in sync.
Wanted to use Pivot table, but....
I need to add data to the rows in additional columns, so a Pivot tabl
update would wipe that out.
Here's an example of the first sheet (source data)
Column A - B - C - D - E
0 1 3 5 14
Q W E R T
the additional sheets must have that data plus...
Column A - B - C - D - E - F - G - H
0 1 3 5 14 Q R 0
Q W E R T A B 5
Can't figure out a way to achieve this, so help would be very muc
appreciated. I've thought about filters, pivots, macros but no on
solution has come to mind.
thanks
scot