G
Greenhorn4now
Hi all! New to forum! Anyway, I want to link worksheets in a folder.
I want to set up a master sheet on which I will enter my data. Th
data will then be entered on other worksheets where desired. Th
problem I have is that many of the worksheets are filled out as a lis
of data. I will need to have the data placed in a certain column i
the next open (unused) row under a specific category. Is there a wa
for Excel to do this? For example; on my master I enter a vehicle
color red, sunroof, produced on 2nd shift. Then have this data entere
in another worksheet under the category 2nd Shift Production in the nex
open row
I want to set up a master sheet on which I will enter my data. Th
data will then be entered on other worksheets where desired. Th
problem I have is that many of the worksheets are filled out as a lis
of data. I will need to have the data placed in a certain column i
the next open (unused) row under a specific category. Is there a wa
for Excel to do this? For example; on my master I enter a vehicle
color red, sunroof, produced on 2nd shift. Then have this data entere
in another worksheet under the category 2nd Shift Production in the nex
open row