ClausSkeel
New Member
- Joined
- Jun 3, 2022
- Messages
- 11
- Office Version
- 365
- Platform
- Windows
- MacOS
Hi all.
I'm currently making an excel sheet that export data from SAP as a script and generating a .htm document.
After this using vba, the excel document will get the data by creating a connecting and hereafter refreshing the sheet once a while.
All this works, the basic thing comes to linking to this table, from another spreadsheet.
When the table get fewer or more rows, the link on another spreadsheet keeps jumping in numbers ex:
$C$20
$C$21
$C$22
$C$32
$C$33
$C$40
I've tried to lock the cells without luck. Can you link to rows in table instead of the sheet?
Revert back, if you want picture or anything, that can help clarify my challenge.
I'm currently making an excel sheet that export data from SAP as a script and generating a .htm document.
After this using vba, the excel document will get the data by creating a connecting and hereafter refreshing the sheet once a while.
All this works, the basic thing comes to linking to this table, from another spreadsheet.
When the table get fewer or more rows, the link on another spreadsheet keeps jumping in numbers ex:
$C$20
$C$21
$C$22
$C$32
$C$33
$C$40
I've tried to lock the cells without luck. Can you link to rows in table instead of the sheet?
Revert back, if you want picture or anything, that can help clarify my challenge.