Hi There
I am trying to copy a line from Spreadsheet A within a Workbook to Spreadsheet B within the same workbook where Cell A in Spreadsheet A is a name and begins with the letter A.
The Workbook is an Alphabetical Dictionary of users and the First Tab has alot of random user information filled and I would like to right a macro with VBA code to copy the relevant information into the corresponding spreadsheets Letter.
i.e. I have a first tab called Info and 26 other tabs named A - Z. Using the Macro would copy information to the next available line for all user with a surname strting with A into Sheet 'A' , B into Sheet 'B' and so on.
Many Thanks In Advance
Steve
I am trying to copy a line from Spreadsheet A within a Workbook to Spreadsheet B within the same workbook where Cell A in Spreadsheet A is a name and begins with the letter A.
The Workbook is an Alphabetical Dictionary of users and the First Tab has alot of random user information filled and I would like to right a macro with VBA code to copy the relevant information into the corresponding spreadsheets Letter.
i.e. I have a first tab called Info and 26 other tabs named A - Z. Using the Macro would copy information to the next available line for all user with a surname strting with A into Sheet 'A' , B into Sheet 'B' and so on.
Many Thanks In Advance
Steve