H
hansjhamm
This is hard to explain...but.
I have a spreadsheet(Report) that I need to import data from another
spreadsheet(Activity).
Typically I use match, index, match formulation in VBA...
The "activity" sheet has text data in column A . This text could be in
7 rows or it may in 20 rows, a constant variable. (These would become
the "headers" on the "report" sheet and the first part of the first
match.)
Numeric data that I need to retrieve is in Columns B & D. (this is the
index)
Here is where the "but" comes in...The second part of the first match
(the match with the "headers") AND second part of the second match
(Store Number) is in column A. The match between the "headers" of the
report and column A of "Activity" is not a problem. It is the store
number match that I have an issue...On the "activity" sheet after each
section of data there is the store number. So, if store 1starts on row
15 and has 5 sections of data the store number would be located in cell
A20. Then starts a new section of data for store 2, which may be 5
sections of data the store number would be located in cell A28, etc...
What I have thought about and tried is an offset; but how do I code it
to know to stop at the next store listing (store number)?
Thanks for any insight you can give me,
Hans
I have a spreadsheet(Report) that I need to import data from another
spreadsheet(Activity).
Typically I use match, index, match formulation in VBA...
The "activity" sheet has text data in column A . This text could be in
7 rows or it may in 20 rows, a constant variable. (These would become
the "headers" on the "report" sheet and the first part of the first
match.)
Numeric data that I need to retrieve is in Columns B & D. (this is the
index)
Here is where the "but" comes in...The second part of the first match
(the match with the "headers") AND second part of the second match
(Store Number) is in column A. The match between the "headers" of the
report and column A of "Activity" is not a problem. It is the store
number match that I have an issue...On the "activity" sheet after each
section of data there is the store number. So, if store 1starts on row
15 and has 5 sections of data the store number would be located in cell
A20. Then starts a new section of data for store 2, which may be 5
sections of data the store number would be located in cell A28, etc...
What I have thought about and tried is an offset; but how do I code it
to know to stop at the next store listing (store number)?
Thanks for any insight you can give me,
Hans