I previously used a small macro to place the contents of the cursor position to a cell in the top LH corner of sheet that could be used as a LOOKUP reference on another tab. It would stay there even if I moved around on the first sheet. Now the Excel file is being used in Sharepoint that will not permit macros I need a "formula" solution.
Any ideas please?? T
Any ideas please?? T