TkdKidSnake
Board Regular
- Joined
- Nov 27, 2012
- Messages
- 245
- Office Version
- 365
- Platform
- Windows
Hi all,
I am looking for some help, I am trying to create code that will move a column of data to another column location on the same worksheet based on the value found in row 1
On my report I have the following headers in row 1 plus many more however these are the important ones
Supplier (A)
Name (B)
Order (C)
Item Number (D)
Receipt Quantity (E)
Quantity Open (F)
Status (G)
Receipt Date (H)
Performance Date (I)
Due Date (J)
Need Date (K)
The issue I have is that these can appear anywhere on the extracted spreadsheet as there locations are user defined and I need several people to be able to produce the data required, next to each of the above there is a the letter for where I need these columns to be moved to. Once they have been moved everything after these columns can be deleted so if this could be part of the above it would be appreciated.
Obviously if anyone can provide the code for one of these and then I only need to replicate the detail for the others only change the search criteria and end location.
Many thanks
I am looking for some help, I am trying to create code that will move a column of data to another column location on the same worksheet based on the value found in row 1
On my report I have the following headers in row 1 plus many more however these are the important ones
Supplier (A)
Name (B)
Order (C)
Item Number (D)
Receipt Quantity (E)
Quantity Open (F)
Status (G)
Receipt Date (H)
Performance Date (I)
Due Date (J)
Need Date (K)
The issue I have is that these can appear anywhere on the extracted spreadsheet as there locations are user defined and I need several people to be able to produce the data required, next to each of the above there is a the letter for where I need these columns to be moved to. Once they have been moved everything after these columns can be deleted so if this could be part of the above it would be appreciated.
Obviously if anyone can provide the code for one of these and then I only need to replicate the detail for the others only change the search criteria and end location.
Many thanks