deadlyliquidx
New Member
- Joined
- Feb 6, 2015
- Messages
- 27
Hey guys,
Basically I have a sheet that extracts data from another sheet based on an index-match formula.
The data is massive and spans 1000 rows so it basically copies the index match formula and equations from a top row and pulls it down for all rows.
Then it paste values for the certain columns that extract data but not for the formulas pulled down.
I already have this done in VBA but I have to manually change it if there is a shift in columns in the other sheet.
What would be great it does want based on an "X" on another header, only touching those columns that have an X on the header.
The attached image shows my case, thanks!
Basically I have a sheet that extracts data from another sheet based on an index-match formula.
The data is massive and spans 1000 rows so it basically copies the index match formula and equations from a top row and pulls it down for all rows.
Then it paste values for the certain columns that extract data but not for the formulas pulled down.
I already have this done in VBA but I have to manually change it if there is a shift in columns in the other sheet.
What would be great it does want based on an "X" on another header, only touching those columns that have an X on the header.
The attached image shows my case, thanks!