Pahickham
New member
- Joined
- Jun 5, 2017
- Messages
- 25
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2013
Sorry in advance for the confusing description, I couldn't think of and easier way to type this.
I'm in need of help regarding copying and pasting data from 2 different data sheets to one "filtered data" sheet based on the inputs of a fourth sheet called "Input"
Currently I have a query setup to the "data" sheet. Every time I download the most recent data entries from a server and save, it will actively change the Inputs on the "data" sheet. From there I go to the "Input" sheet and type the top priority numbers so it will filter the desired data from "data" and "data 2" sheets to the "filtered data" sheet.
Attached are a before and after example of what I'm looking form. Is this possible?
Thank you for any responses in advance.
View attachment Start.xlsx View attachment Finish.xlsx
Mr.Excel Link:
https://www.mrexcel.com/board/threa...tiple-sheets-based-on-1-sheets-input.1119689/
I'm in need of help regarding copying and pasting data from 2 different data sheets to one "filtered data" sheet based on the inputs of a fourth sheet called "Input"
Currently I have a query setup to the "data" sheet. Every time I download the most recent data entries from a server and save, it will actively change the Inputs on the "data" sheet. From there I go to the "Input" sheet and type the top priority numbers so it will filter the desired data from "data" and "data 2" sheets to the "filtered data" sheet.
Attached are a before and after example of what I'm looking form. Is this possible?
Thank you for any responses in advance.
View attachment Start.xlsx View attachment Finish.xlsx
Mr.Excel Link:
https://www.mrexcel.com/board/threa...tiple-sheets-based-on-1-sheets-input.1119689/
Last edited: