I am relativley new to VBA and I am trying to write a code that does the following:
- Locates a specific cell based on its content e.g. (Item being forwarded to domestic processing workcentre)
- Selects a cell that is in the same row as this content but different column
- Copies this cell to clipboard
- Pastes this value into a different workbook.
Any help is greatly appreciated.
Thanks,
Janyce