LinkBack URL
About LinkBacks
I need to match Model and week in both source and destination tabs and then pull in the "WM Total" for that week into the destination tab for each model. I would really apprecicate the help.
Here is an example. Thanks.
I need to match Model and week in both source and destination tabs and then pull in the "WM Total" for that week into the destination tab for each model. I would really apprecicate the help.
Here is an example. Thanks.
if its always laid out like that in
destination!d2
=OFFSET(Source!$C$2,24,MATCH($C2,Source!$C$2:$M$2,0)-1)
in destination!e2
=OFFSET(Source!$C$2,51,MATCH($C2,Source!$C$2:$M$2,0)-1)
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
That worked great. The problem is that I will have to always know the line "WM Total" is on. I am going to be referecing different tabs where the layout is usually 98% similar but not always the same and there is a lot of data and will be too much work to figure out the line for every "WM Total". I was looking for a way to search for the text whichever line it's on.
youll have to change the layout then just put U380 Brightside next to total then look that up
That's the problem. I can't change the layout in the source. It's a file with different tabs that is used in another department and they have used that for years. I gave this is an example so that once I get the formula I can then edit it for the real source file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks