Hello can someone help me out with this one. I have an excel file with +30k rows and 61 columns data so i need to use vba. Basically i want to copy duplicates according to 3 columns in to a new sheet. Columns are AA - AB - AC;
So it would be like , first 3 rows that have 1-01-00 on specified columns to a new sheet and then values that have 1-01-01 to different sheet and 1-01-02 and so on. Ideally i wd like to have fixed header for all of them. My Column range is A-BI; row range is 1 - 33372; thanx in advance
So it would be like , first 3 rows that have 1-01-00 on specified columns to a new sheet and then values that have 1-01-01 to different sheet and 1-01-02 and so on. Ideally i wd like to have fixed header for all of them. My Column range is A-BI; row range is 1 - 33372; thanx in advance