jsmith2094
New Member
- Joined
- Aug 19, 2021
- Messages
- 35
- Office Version
- 365
- Platform
- Windows
Hey,
I have a workbook that has multiple sheets , on sheet1 I have data in column A which each cell has text and numbers for example: 10404040405 John Smith LTD, each other sheets on the workbook are the same.
I need a macro that searches the numbers only in column A on sheet1 and finds the exact match on the other sheets then from the sheet it finds it from copy the contents on column E which has a price for example £9.99 then paste it back in sheet1 column E
any ideas?
I have a workbook that has multiple sheets , on sheet1 I have data in column A which each cell has text and numbers for example: 10404040405 John Smith LTD, each other sheets on the workbook are the same.
I need a macro that searches the numbers only in column A on sheet1 and finds the exact match on the other sheets then from the sheet it finds it from copy the contents on column E which has a price for example £9.99 then paste it back in sheet1 column E
any ideas?