Vbalearner85
Board Regular
- Joined
- Jun 9, 2019
- Messages
- 139
- Office Version
- 2016
- Platform
- Windows
Hi,
I have sheet name "Index" which in Column A (starting cell A2) contains hyperlinks (sheet name) to each sheet cell reference "A5"
I want to create a macro which shall :-
1) link and display data of each sheet cell reference "A3" in Index sheet (in column B of sheet "Index", corresponding to sheet name hyperlink in column A of same sheet "Index")
2) link and display data of each sheet cell reference "C9" in Index sheet (in column C of sheet "Index", corresponding to sheet name hyperlink in column A of same sheet "Index")
3) link and display data of each sheet cell reference "F12" in Index sheet (in column D of sheet "Index", corresponding to sheet name hyperlink in column A of same sheet "Index")
4) Put a formula "= max(Sheetname!D:D)" (in column E of sheet "Index", corresponding to sheet name hyperlink in column A of same sheet "Index")
5) Put a formula "= min(Sheetname!E:E)" (in column F of sheet "Index", corresponding to sheet name hyperlink in column A of same sheet "Index") and shall ignore blank cells- so as not to give 0 values
Regards,
PK
I have sheet name "Index" which in Column A (starting cell A2) contains hyperlinks (sheet name) to each sheet cell reference "A5"
I want to create a macro which shall :-
1) link and display data of each sheet cell reference "A3" in Index sheet (in column B of sheet "Index", corresponding to sheet name hyperlink in column A of same sheet "Index")
2) link and display data of each sheet cell reference "C9" in Index sheet (in column C of sheet "Index", corresponding to sheet name hyperlink in column A of same sheet "Index")
3) link and display data of each sheet cell reference "F12" in Index sheet (in column D of sheet "Index", corresponding to sheet name hyperlink in column A of same sheet "Index")
4) Put a formula "= max(Sheetname!D:D)" (in column E of sheet "Index", corresponding to sheet name hyperlink in column A of same sheet "Index")
5) Put a formula "= min(Sheetname!E:E)" (in column F of sheet "Index", corresponding to sheet name hyperlink in column A of same sheet "Index") and shall ignore blank cells- so as not to give 0 values
Regards,
PK