Macro to find and copy all columns

Closed
iceteee Posts 2 Registration date Sunday January 9, 2011 Status Member Last seen January 10, 2011 - Jan 9, 2011 at 11:35 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 19, 2011 at 09:32 AM
Dear all,

I've searched online for 2hours but still unable to find suitable threads, please direct me to the information or help me out with the following problem.


I have a spreadsheet with many columns with headings of Mon, Tue, Wed, Thu, Fri, Sat, Sun, Mon, Tue, Wed, Thu, Fri etc it just repeats the weekdays

I need a macro to help me select all the columns with the heading Mon and copy it to worksheet named Mon (from cell A1).

I also need the macro for selecting Tue -> copy to worksheet Tue, but I guess I can just edit the code from the Mon one.

Much appreciation for any help :)
Thanks!


1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jan 19, 2011 at 09:32 AM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.


Note:
your data need not be to be real data but a good representative of how data looks like
0