Good Morning Folks.
I am Trying to get data Between Sheetnames IGNORE1 and IGNORE2
On Each Sheet Between IGNORE1 and IGNORE2 D3 is a Site Designation...These Change on Each Sheet...
on each sheet between IGNORE1and IGNORE2 There is a Range of data found in F3:N That i only want to fill to the IMPORT tab if theres Data in Column G
Lets say theres 2 sheets Between IGNORE1 and IGNORE2
The Result on the IMPORT Tab should Look Like this
The First COLUMN is Data from D3 Between IGNORE1 and IGNORE2
The columns next to that are data from those tabs F3:N
This is a Sheet Between IGNORE1 and IGNORE2
another sheet Between INGORE 1 and IGNORE2
End Result on Import Tab:
Thank you for your time!
I am Trying to get data Between Sheetnames IGNORE1 and IGNORE2
On Each Sheet Between IGNORE1 and IGNORE2 D3 is a Site Designation...These Change on Each Sheet...
on each sheet between IGNORE1and IGNORE2 There is a Range of data found in F3:N That i only want to fill to the IMPORT tab if theres Data in Column G
Lets say theres 2 sheets Between IGNORE1 and IGNORE2
The Result on the IMPORT Tab should Look Like this
The First COLUMN is Data from D3 Between IGNORE1 and IGNORE2
The columns next to that are data from those tabs F3:N
This is a Sheet Between IGNORE1 and IGNORE2
D3 | F | G | H | I etc... | N |
WI-DAR | Front | Rear | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
WI-DAR | Front Side | ||||||||
WI-DAR | Front1 | Rear1 | a | b | c | d | e | f | g |
another sheet Between INGORE 1 and IGNORE2
D3 | F | G | H | I etc... | N |
PA-CHM | Front2 | Rear2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
PA-CHM | Front3 | Rear3 | a | b | c | d | e | f | g |
PA-CHM | Front side | ||||||||
PA-CHM | Front4 | Rear4 | 100 | 200 | 300 | 400 | 500 | 600 | 700 |
PA-CHM | Front5 | Rear5 | aaa | bbb | ccc | ddd | eee | fff | ggg |
PA-CHM | Front6 |
End Result on Import Tab:
Data FROM D3 | F | G | H | I etc... | N | ||||
WI-DAR | Front | Rear | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
WI-DAR | Front1 | Rear1 | a | b | c | d | e | f | g |
PA-CHM | Front2 | Rear2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
PA-CHM | Front3 | Rear3 | a | b | c | d | e | f | g |
PA-CHM | Front4 | Rear4 | 100 | 200 | 300 | 400 | 500 | 600 | 700 |
PA-CHM | Front5 | Rear5 | aaa | bbb | ccc | ddd | eee | fff | ggg |
Thank you for your time!
Last edited: