acerlaptop
New Member
- Joined
- Feb 17, 2020
- Messages
- 44
- Office Version
- 2013
- Platform
- Windows
Hi,
Can anyone help with this:
Data range:
Range (A2) to last row in column G
Worksheets:
Main - SUMMARY (column H is where i'll put hyperlink - with header)
Other worksheets
Criteria for address:
1. column I (my helper column) of SUMMARY equals Worksheet name (select)
2. Value in column A of SUMMARY equals value of Column A of selected worksheet
3. address will be the cell in column H that passed the criterias
That's all. Hope you can help me.
Thanks
Can anyone help with this:
Data range:
Range (A2) to last row in column G
Worksheets:
Main - SUMMARY (column H is where i'll put hyperlink - with header)
Other worksheets
Criteria for address:
1. column I (my helper column) of SUMMARY equals Worksheet name (select)
2. Value in column A of SUMMARY equals value of Column A of selected worksheet
3. address will be the cell in column H that passed the criterias
That's all. Hope you can help me.
Thanks