MS Excel VBA (Macros)
Budget: $10 – $30 USD
The project is as follows
Move some cells from one row in some columns to the same column one and then delete rows of copied cells.
Example
Lookup column B value ”6949785206893” (Row #2)
Result: column A “6949785206893” (Row #3)
Copy Cells of columns E, F, H, P, Q, R, S, T, U, V, W, AU, AV (Row #3)
Paste in Cells of columns E, F, H, P, Q, R, S, T, U, V, W, AU, AV (Row #2)
Delete an entire row of Result: column A “6949785206893” (Row #3)
Continue to next till the end of the sheet (could be up to 40,000 rows)
Possible that other sheets need to be created to combine the proper data or to have the lookup values.
Also, you may need to add sheets to copy-paste data
Move some cells from one row in some columns to the same column one and then delete rows of copied cells.
Example
Lookup column B value ”6949785206893” (Row #2)
Result: column A “6949785206893” (Row #3)
Copy Cells of columns E, F, H, P, Q, R, S, T, U, V, W, AU, AV (Row #3)
Paste in Cells of columns E, F, H, P, Q, R, S, T, U, V, W, AU, AV (Row #2)
Delete an entire row of Result: column A “6949785206893” (Row #3)
Continue to next till the end of the sheet (could be up to 40,000 rows)
Possible that other sheets need to be created to combine the proper data or to have the lookup values.
Also, you may need to add sheets to copy-paste data