• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Arrange excel sheet with Macro

J

jack999

Member
I need to maintain excel sheet daily basis which is imported from another database. The imported excel sheet is not in a proper order. I want to arrange that sheet by following steps. There are several unwanted columns and rows, some columns are merged. I would like to arrange the sheet by follows steps with the help of macro. Can you help me?


Select A: BZ columns UNMERGE & unwrap ALL COLUMNS AND ROWS



Copy B1 Title to C1

Copy H1 Title to J1

Copy N1 Title to O1



Column L width to 35

Column O width to 37

Column AI with 27

Delete Column B

Delete Column C:H

Delete Column D

Delete Column E:F

Delete column F to X

Delete G: BX

Delete rows 2,4,6,8,10, …… 500


Select A:F column

Border all
 
Check.
There were few things ...
I set 'Job Date's width' and
If 'Delete rows 2,4,6,8,10, …… 500'
... then all data rows will be delete.
'Border all' ... can be something else too.
 

Attachments

  • jack999.xlsm
    28 KB · Views: 3
vletm said:
Check.
There were few things ...
I set 'Job Date's width' and
If 'Delete rows 2,4,6,8,10, …… 500'
... then all data rows will be delete.
'Border all' ... can be something else too.
Click to expand...

Need inside and outside line also. Can we append data from another active file.
For example this imported file(jack999) is for 01.10.2015 the next day report file need to append in the bottom of this file record after arrange with macro. can it possible
 

Attachments

  • jack999.xlsm
    22.9 KB · Views: 1
All borders are Okay.
Instructions were columns A:F - border all; that's why only left & right (F-col)
You mean that next time, a1:e6 - border all.
Appending is possible, if datas collect to another sheet.
Do it need empty row between date reports?
 
Next version ...
I did the 'Master'-tab ... It's for collection of all datas.
You should copy 'new data' to 'Import'-tab and
after that Run Macro.
The 'new data' will move to 'Master'-tab ... if there isn't already same data.
Test and tell ideas?
 

Attachments

  • jack999.xlsm
    36.5 KB · Views: 2
vletm said:
Next version ...
I did the 'Master'-tab ... It's for collection of all datas.
You should copy 'new data' to 'Import'-tab and
after that Run Macro.
The 'new data' will move to 'Master'-tab ... if there isn't already same data.
Test and tell ideas?
Click to expand...

Thanks a lot. Very Good.

Column (AI) Sales Person and Name need to keep in the file.
 
You must log in or register to reply here.
Back
Top