G
Guest
Sorry if this is showing twice, I could see my question last week but now I
can't find it anywhere???
I am trying to do this:
Value of A1 on sheet 1 will match the value of either D1,E1,F1...P1 of sheet 2
Assuming it matches E1, I want to copy E2:E52 of sheet 2 over to B1:B51 of
sheet 1
I don't think it matters but in case it does, the value that will be in A1
is actually {='sheet 3'!B3} and in my example above E1 would also be {='sheet
3'!B3}
So I should always have an exclusive, exact match but I can't get the
wording right. Can I even do this? If I have to I can replace my A1 and
D-P1's with text but I would rather not so that I can add duplicate sheets to
the Workbook (Values of D1 through P1 each has a ws of same name) with
minimal or no editing of the macro.
Please HELP!?!?
can't find it anywhere???
I am trying to do this:
Value of A1 on sheet 1 will match the value of either D1,E1,F1...P1 of sheet 2
Assuming it matches E1, I want to copy E2:E52 of sheet 2 over to B1:B51 of
sheet 1
I don't think it matters but in case it does, the value that will be in A1
is actually {='sheet 3'!B3} and in my example above E1 would also be {='sheet
3'!B3}
So I should always have an exclusive, exact match but I can't get the
wording right. Can I even do this? If I have to I can replace my A1 and
D-P1's with text but I would rather not so that I can add duplicate sheets to
the Workbook (Values of D1 through P1 each has a ws of same name) with
minimal or no editing of the macro.
Please HELP!?!?