Excel Macro for sort certain columns if a large excel spreadsheet
$30-250 USD
Terminado
Publicado hace casi 9 años
$30-250 USD
Pagado a la entrega
Excel Macro to sort the data of certain columns
Say we have an Excel Spread sheet may contain 20 columns and 300 rows, and I want to move the cells of the first 4 columns (say Column A, Column B, Column C, and Column D) in such a way so that the text value of the Cell in Column A equals to that of Column E
For example
Now:
Column A Column B Column C Column D Column E Column F ...
Row1 FUAX650 30 2 FUAX550 Fuji AX550 Cameara
Row2 FUAX850 20 1.2 FUAX650 Fuji AX650 Cameara
Row3 FUAX950 50 2.5 FUAX750 Fuji AX750 Cameara
Row4 FUAX1050 100 2.8 FUAX950 Fuji AX950 Cameara
Row5 FUAX750 60 1.9 FUAX1050 Fuji AX1050 Camera
...
After:
Column A Column B Column C Column D Column E Column F ...
Row1 FUAX550 Fuji AX550 Cameara
Row2 FUAX650 30 2 FUAX650 Fuji AX650 Cameara
Row3 FUAX750 60 1.9 FUAX750 Fuji AX750 Cameara
Row4 FUAX950 50 2.5 FUAX950 Fuji AX950 Cameara
Row5 FUAX1050 100 2.8 FUAX1050 Fuji AX1050 Camera
...
Please also see attached Excel file which has two sheets "now" and "after", basically after running the Macro for the "now" sheet, the result should be the same as "after" sheet.
Hello sir... I provide very fast work & guarantee you 100% satisfaction and my expertise lies in quality service and delivery on Time kindly if you wants high quality work then as soon as possible discuss me. Please give me chance to prove myself. Thank u!
Hi,
Let handle your works to professionals.
I am an excel expert in the field.
I can guarantee 100% accuracy and quick completion.
You can view my reviews to assure quality of my works.
Hope to hear you from soon.