SWETHAKHATRI88
New Member
- Joined
- Jul 29, 2022
- Messages
- 10
- Office Version
- 2021
- Platform
- MacOS
Hi. I have an excel workbook with 2 key sheets Control and Combine. Based on a column in sheet combined, multiple new worksheets are created based on a macro(Not consistent number of new sheets). There is also a string called Balance in every worksheet except control and combined
I would like to search the Balance word in every worksheet except control and combined, copy the adjacent cell value, find the corresponding sheet name in control (which is also there in Q2 of every sheet, match the dates (q3 in every sheet) and populate the adjacent cell value for all worksheets
Attached is my sheet for reference. Can this be done through vba. Thanks in advance.
I am aware Index match can solve but am able to do only for one sheet
Control sheet looks like below
Worksheet looks like below
I would like to search the Balance word in every worksheet except control and combined, copy the adjacent cell value, find the corresponding sheet name in control (which is also there in Q2 of every sheet, match the dates (q3 in every sheet) and populate the adjacent cell value for all worksheets
Attached is my sheet for reference. Can this be done through vba. Thanks in advance.
I am aware Index match can solve but am able to do only for one sheet
Control sheet looks like below
04/10/2023 | 04/10/2023 | 05/10/2023 | 05/10/2023 | |
OB | BALANCE | OB | BALANCE | |
test1 | ||||
test2 | ||||
Worksheet looks like below
Column Q | Column R | ||
test1 | |||
04/10/2023 | |||
OB | 100 | ||
BALANCE | 50 |