C
cyndiwise notsowise
I have an Excel worksheet in which I am tracking my inventory of items to
sell. I want to create a new worksheet that pulls only certain columns of
data from the existing worksheet. I want the new worksheet linked to the
existing worksheet so that as data is added, deleted, or changed, it is
reflected in the new worksheet.
In the new worksheet, I want to be able to create formulas using certain
data from the existing worksheet. I want to include ALL rows from the
existing worksheet (each row is ONE inventory item), but only some of the
columns of data. I hope this makes some sense, and that it is possible.
Thanks for your suggestions.
sell. I want to create a new worksheet that pulls only certain columns of
data from the existing worksheet. I want the new worksheet linked to the
existing worksheet so that as data is added, deleted, or changed, it is
reflected in the new worksheet.
In the new worksheet, I want to be able to create formulas using certain
data from the existing worksheet. I want to include ALL rows from the
existing worksheet (each row is ONE inventory item), but only some of the
columns of data. I hope this makes some sense, and that it is possible.
Thanks for your suggestions.