Hi Gurus,
I've searched the net extensively for an answer to this question but perhaps I'm looking in the wrong places. I need to copy information from specific cells on one spreadsheet to specific cells on another. The problem is that the names of the spreadsheets will not always be consistant. Is there a way in VBA to request the user of a form to select the spreadsheets they want to copy from and too and then somehow reference these in the code?
Any help greatly appreciated?
Dave
I've searched the net extensively for an answer to this question but perhaps I'm looking in the wrong places. I need to copy information from specific cells on one spreadsheet to specific cells on another. The problem is that the names of the spreadsheets will not always be consistant. Is there a way in VBA to request the user of a form to select the spreadsheets they want to copy from and too and then somehow reference these in the code?
Any help greatly appreciated?
Dave