Hi,
First of I am new to posting on this forum, but have been using it a nomerous of times, and it has been of great help when I have been stuck in Excel, so thank you all for your contributions!
I have been searching the last hour for how to shorten the formula below/create a VBA function/make a macro to autofill it, with out any luck:
=HYPERLINK("#'Raw data'!"&SUBSTITUTE(ADDRESS(1;1+51);"1";"")&MATCH($B$2;'Raw data'!$B:$B;0);VLOOKUP($B$2;'Raw data'!$B$4:$CZ$86;51;FALSE))
What I am trying to do is to preferably create a function where i only type something along the lines of this in a cell: =short(51,B2) where the number and cell reference would be the variable (as this function would be used on a lot of cells). Another option would be that the full formula would be put in the cell, but where i only needed to write i.e. =short(30,B1) to call forth the formula with the number and cell change - thus not having to copy and change the whole formula for each cell.
I appreciate any help I can get!
Best regards
Anders
First of I am new to posting on this forum, but have been using it a nomerous of times, and it has been of great help when I have been stuck in Excel, so thank you all for your contributions!
I have been searching the last hour for how to shorten the formula below/create a VBA function/make a macro to autofill it, with out any luck:
=HYPERLINK("#'Raw data'!"&SUBSTITUTE(ADDRESS(1;1+51);"1";"")&MATCH($B$2;'Raw data'!$B:$B;0);VLOOKUP($B$2;'Raw data'!$B$4:$CZ$86;51;FALSE))
What I am trying to do is to preferably create a function where i only type something along the lines of this in a cell: =short(51,B2) where the number and cell reference would be the variable (as this function would be used on a lot of cells). Another option would be that the full formula would be put in the cell, but where i only needed to write i.e. =short(30,B1) to call forth the formula with the number and cell change - thus not having to copy and change the whole formula for each cell.
I appreciate any help I can get!
Best regards
Anders