S
srg_rector
I am using Office 2003. I have a large Excel data file that I need to pull
specific info from.
I want to be able to have a worksheet that automatically pulls
specific/limited data from the Main Worksheet to a number of Result
Worksheets. There can be no blank rows in the Result Worksheets. The
result worksheets can have ONLY the data from Columns M-Q in them.
I have looked at: lookup, vlookup, index, match, and other functions, but I
cannot figure out how to get this to work.
The NGP/CNF/CNT codes will not be grouped in the Main Worksheet; the Main
Worksheet MUST be sorted by Date: Descending.
The Result Worksheets must update themselves whenever the Main Worksheet
data changes.
Result Worksheet NGP:
Criteria to select data record: Main Worksheet Column G must have the text
"NGP"
Data to write to Result Worksheet NGP: Main Worksheet same data record
Columns M-Q
There can be no blank rows in the Result Worksheets.
Result Worksheet CNF:
Criteria to select data record: Main Worksheet Column H must have the text
"CNF"
Data to write to Result Worksheet CNF: Main Worksheet same data record
Columns M-Q
There can be no blank rows in the Result Worksheets.
Result Worksheet CNT:
Criteria to select data record: Main Worksheet Column I must have the text
"CNT"
Data to write to Result Worksheet CNT: Main Worksheet same data record
Columns M-Q
There can be no blank rows in the Result Worksheets.
Please tell me how to write these worksheets!
Thanks!!!
Sheri
specific info from.
I want to be able to have a worksheet that automatically pulls
specific/limited data from the Main Worksheet to a number of Result
Worksheets. There can be no blank rows in the Result Worksheets. The
result worksheets can have ONLY the data from Columns M-Q in them.
I have looked at: lookup, vlookup, index, match, and other functions, but I
cannot figure out how to get this to work.
The NGP/CNF/CNT codes will not be grouped in the Main Worksheet; the Main
Worksheet MUST be sorted by Date: Descending.
The Result Worksheets must update themselves whenever the Main Worksheet
data changes.
Result Worksheet NGP:
Criteria to select data record: Main Worksheet Column G must have the text
"NGP"
Data to write to Result Worksheet NGP: Main Worksheet same data record
Columns M-Q
There can be no blank rows in the Result Worksheets.
Result Worksheet CNF:
Criteria to select data record: Main Worksheet Column H must have the text
"CNF"
Data to write to Result Worksheet CNF: Main Worksheet same data record
Columns M-Q
There can be no blank rows in the Result Worksheets.
Result Worksheet CNT:
Criteria to select data record: Main Worksheet Column I must have the text
"CNT"
Data to write to Result Worksheet CNT: Main Worksheet same data record
Columns M-Q
There can be no blank rows in the Result Worksheets.
Please tell me how to write these worksheets!
Thanks!!!
Sheri