Hi to all experts,
I have a workbook with multiple sheets with same structure. What i want to do is consolidate only the specific cells with same header using vba(from vertical to horizontal)
Report is between A1:AN96 veritically, i need a1 and then horizotally AL6-AL20-AL24-AL26-................
There ise a sample file of the report. I need to consolidate yellow cells..
Thanks a lot in advance...
Last edited by erd0w; 01-23-2022 at 12:58 PM.
Try
in B2
=INDEX(INDIRECT("'" &$A2& "'!al6:Al49"),MATCH(B$1,INDIRECT("'" &$A2& "'!I6:i49"),0))
copy across to E
in F2
=INDIRECT("'" &$A2 &"'!$AM$26")
similar for other ranges
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
I want to do it using vba
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks