I get a spreadsheet every few days from someone, always in the same format. I need to manipulate and filter it.
What I would like to do is:
Paste the new sheet over top of the old one in my workbook.
Sheet 2 references sheet 1 and then does all the calculations.
Sheet 3-9 are final worksheets, each a subset of the items on sheet 2.
As an example lets say I get data with these columns:
Id, Name, Format, Price, #inStock
I manipulate this to get
Id, Name, Format, Price, #inStock, MyId, MyName, MyPrice
Now, on sheet 3 I just want
MyId, MyName, MyPrice
for all items where #inStock >0 and format =x
On sheet 4 I just want
MyId, MyName, MyPrice
for all items where #inStock >0 and format =y
etc...
In a way that just recalculates and filters every time I paste in a new dataset.
I'm partly there, but things never seem to work like I want. It's a nifty little problem if anyone here has an idea.
From the posts I've ready, someone's able to do this
