William F.
New member
- Joined
- Apr 28, 2014
- Messages
- 7
- Reaction score
- 0
- Points
- 0
Not entirely sure how to explain what I am trying to do but I'll give it a shot.
What I have is master list of workboots with various columns of data.
What I want to be able to do is have several different worksheets pull data from this. For instance I want one Spreadsheet that has everything on the Master sorted by one column. Then another Spreadsheet that has only certain columns sorted differently. Then several other spreadsheets that have some columns, but to only include rows that contain certain data(I think I can do this on with Filter, not sure though).
As it is right now we need all those different sheets, but every time a customer asks for a list of boots that meet certain requirements I just copy the master, delete the columns I do not need and do a sort. Then, I need to go and manually update all spreadsheets when something changes in the Master list. Anytime we receive a price increase I need to go into dozens of different spreadsheets and update prices. Anytime we bring on a new item I have to manually add it to several places. I think you get the picture.
Is something like this even possible? I have done some googling and looking around but not finding anything very helpful.
Hope that makes sense.
What I have is master list of workboots with various columns of data.
What I want to be able to do is have several different worksheets pull data from this. For instance I want one Spreadsheet that has everything on the Master sorted by one column. Then another Spreadsheet that has only certain columns sorted differently. Then several other spreadsheets that have some columns, but to only include rows that contain certain data(I think I can do this on with Filter, not sure though).
As it is right now we need all those different sheets, but every time a customer asks for a list of boots that meet certain requirements I just copy the master, delete the columns I do not need and do a sort. Then, I need to go and manually update all spreadsheets when something changes in the Master list. Anytime we receive a price increase I need to go into dozens of different spreadsheets and update prices. Anytime we bring on a new item I have to manually add it to several places. I think you get the picture.
Is something like this even possible? I have done some googling and looking around but not finding anything very helpful.
Hope that makes sense.