Previous Topic Next Topic

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 4478 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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

Comparing columns and returning value
ll -
kittu -

35 responses
Code for macro that conditionally inserts rows
bfleming -
bfleming -

4 responses
VBA find column by name and sort
SidK -
bOFILL -

4 responses
Extract identical cells of 2 columns (excel)
Little bit lost -
keliza -

3 responses
copy a row from one worksheet to another, based on criteria
wy -
vcoolio -

15 responses