J
jello523
I read through the solution for Multiple Matched Lines and tried to adapt it
to my worksheets. Unfortunately, I am having a few problems.
All of my worksheets are in the same workbook. The worksheet I am trying to
update is formatted as a report and has a five-row section (B19:L23) that
should contain data copied from a worksheet called AFO_Data. AFO_Data
contains 60 rows and 12 columns of data (A1:L60). I want to copy only those
rows where data in column A matches cell A1 on the Report worksheet. In all
but one case, this involves five rows of data. In the other case, only four
rows. The contents of Reports!$A$1 is a text field (01, 02, 03, 04, 05, 06,
08, 09, 10, 11, 12, 13) formulated from a third worksheet using OFFSET.
Using the solution from "Multiple Matched Lines", I get data from the
AFO_Data worksheet that is in the same row as where I need it copied to in
the first worksheet (i.e. AFO_Data!B19:L23). I'm sure it is because I edited
the IF statement for only one input (rather than a date range used in the
example solution) and I really don't know what I'm doing. How can I get it
to read the correct row number for the data I need based on matching the data
in Reports!$A$1?
Thank you for any help on this you can provide. If you need clarification
or samples of my code, please let me know.
to my worksheets. Unfortunately, I am having a few problems.
All of my worksheets are in the same workbook. The worksheet I am trying to
update is formatted as a report and has a five-row section (B19:L23) that
should contain data copied from a worksheet called AFO_Data. AFO_Data
contains 60 rows and 12 columns of data (A1:L60). I want to copy only those
rows where data in column A matches cell A1 on the Report worksheet. In all
but one case, this involves five rows of data. In the other case, only four
rows. The contents of Reports!$A$1 is a text field (01, 02, 03, 04, 05, 06,
08, 09, 10, 11, 12, 13) formulated from a third worksheet using OFFSET.
Using the solution from "Multiple Matched Lines", I get data from the
AFO_Data worksheet that is in the same row as where I need it copied to in
the first worksheet (i.e. AFO_Data!B19:L23). I'm sure it is because I edited
the IF statement for only one input (rather than a date range used in the
example solution) and I really don't know what I'm doing. How can I get it
to read the correct row number for the data I need based on matching the data
in Reports!$A$1?
Thank you for any help on this you can provide. If you need clarification
or samples of my code, please let me know.