G
Guest
Came across this old thread, which was similar to what I needed, but
unfortunately the solutions recommended back then involved doing the
worksheet other ways.
So my question is: If I have a list on one worksheet, which is then copied
to a second worksheet, how do I ensure the second updates if I add new rows
or change the text to the first.
Kind Regards
A Taxed Mind
Previous thread starting Q.
Subject: Copy data into another worksheet and have it update automatically?
3/30/2006 7:55 AM PST
By: Lmarie6 In: microsoft.public.excel.misc
My boss sent me a workbook that at present contains only one sheet, however
he wants me to copy certain data (depending on column A) into a second sheet
and other data into a third sheet, but have it update on sheets 2 and 3 when
the data on sheet1 is changed, added, or deleted. Column A contains a
general classification, and he wants certain classifications on sheet2 and
other classifications on sheet3. There are no formulas, just data. It's
just a big list of materials and their locations and vendors, etc. Can this
be done?
unfortunately the solutions recommended back then involved doing the
worksheet other ways.
So my question is: If I have a list on one worksheet, which is then copied
to a second worksheet, how do I ensure the second updates if I add new rows
or change the text to the first.
Kind Regards
A Taxed Mind
Previous thread starting Q.
Subject: Copy data into another worksheet and have it update automatically?
3/30/2006 7:55 AM PST
By: Lmarie6 In: microsoft.public.excel.misc
My boss sent me a workbook that at present contains only one sheet, however
he wants me to copy certain data (depending on column A) into a second sheet
and other data into a third sheet, but have it update on sheets 2 and 3 when
the data on sheet1 is changed, added, or deleted. Column A contains a
general classification, and he wants certain classifications on sheet2 and
other classifications on sheet3. There are no formulas, just data. It's
just a big list of materials and their locations and vendors, etc. Can this
be done?