Currently
I Input manually into spreadsheet A
run a macro to transfer selected data from SSA to SSB inputting new data into next available empty cell. so i end up with new data on one row, column A in SSB has a list of reference numbers in it, in the format "CRBI010001".
the macro then saves SSC based on the value in column A for the newly updated row.
So for example, the last used line is against reference CRBI010006, I run my macro and it adds all the new data to the next row in SSB which will have reference CRBI010007 in column a and then save SSC as filename CRBI010007
What I now want the macro to do is hyperlink the text in column a for that new line to the new file the macro has just created.
Can a macro do that ? for the record the newly save files will all be stored in the same location.
Thanks
James
I Input manually into spreadsheet A
run a macro to transfer selected data from SSA to SSB inputting new data into next available empty cell. so i end up with new data on one row, column A in SSB has a list of reference numbers in it, in the format "CRBI010001".
the macro then saves SSC based on the value in column A for the newly updated row.
So for example, the last used line is against reference CRBI010006, I run my macro and it adds all the new data to the next row in SSB which will have reference CRBI010007 in column a and then save SSC as filename CRBI010007
What I now want the macro to do is hyperlink the text in column a for that new line to the new file the macro has just created.
Can a macro do that ? for the record the newly save files will all be stored in the same location.
Thanks
James