Tom2020
New Member
- Joined
- Aug 6, 2021
- Messages
- 14
- Office Version
- 365
- 2019
- 2016
- 2013
- 2010
- Platform
- Windows
Hi
Maybe I can get some better Solution.
In a For...Next statement, I try to copy data of current Row (sheet 002) to an another sheet (called summery). I don’t need all information of 002, but few (002 has more than 36 columns and will be created from a Master sheet… in next would be named 003 and so forth).
In a step of statement, I have below code works very well. In the column P, it puts sheet name, 002 and creates a link to, exactly to A1 of 002.
Now, I try to change that and to get hyperlink to the cell (from column A), below to current Row.
Thx for help
Maybe I can get some better Solution.
In a For...Next statement, I try to copy data of current Row (sheet 002) to an another sheet (called summery). I don’t need all information of 002, but few (002 has more than 36 columns and will be created from a Master sheet… in next would be named 003 and so forth).
In a step of statement, I have below code works very well. In the column P, it puts sheet name, 002 and creates a link to, exactly to A1 of 002.
Now, I try to change that and to get hyperlink to the cell (from column A), below to current Row.
Thx for help
VBA Code:
Worksheets("summery").Hyperlinks.Add Anchor:=Sheets("summery").Range("P" & (lastRow + 1)), Address:="", SubAddress:="'" & Worksheets(TableName).Name & "'![B]A1[/B]", TextToDisplay:="'" & Worksheets(TableName).Name