Find columns with the same name and copy to new worksheet

thedeadzeds

Active Member
Joined
Aug 16, 2011
Messages
356
Office Version
  1. 365
Platform
  1. Windows
Hi Guys.

I have a table which is exported daily. As you can see lots of columns contain the same name. I would like to create 3 seperate worksheets. 1 containing all of the Bonus Columns, 1 containing all of the Back Columns, and one containing all of the Front Columns. Also, each worksheet should also include Site, Name, Type and Sale

Many thanks

SiteNameStageResultTypeOrderSaleBonusBonusBonusBonusBonusFrontFrontFrontFrontFrontFrontBackBackBackBackBackBack
CardiffSteve1YNewYn10243852668094108122136150164178192206220234
CardiffJim1NUsedyn11253953678195109123137151165179193207221235
CardiffDave1NUsedyn15294357718599113127141155169183197211225239
CardiffSteve1NUsedyn253953678195109123137151165179193207221235249
CardiffJim4NUsedyn4256708498112126140154168182196210224238252266
CardiffDave3YUsedyy52668094108122136150164178192206220234248262276
CardiffMatt5YUsedny5193347617589103117131145159173187201215229
CardiffDave6YUsedny54688296110124138152166180194208222236250264278
CardiffMatt8NUsedny12264054688296110124138152166180194208222236
BirminghamSteve1NUsedny12264054688296110124138152166180194208222236
BirminghamJim1NNewny3173145597387101115129143157171185199213227
BirminghamDave1YNewyn657993107121135149163177191205219233247261275289
BirminghamMatt2YNewyy8599113127141155169183197211225239253267281295309
BirminghamDave2NNewyy7213549637791105119133147161175189203217231
BirminghamSteve2YNewyy48627690104118132146160174188202216230244258272
BirminghamJim2YNewyy9233751657993107121135149163177191205219233
BirminghamDave2NNewyy8223650647892106120134148162176190204218232
BirminghamMatt2NNewnn5193347617589103117131145159173187201215229
BristolSteve3YNewnn12264054688296110124138152166180194208222236
BristolSteve4YNewnn13274155698397111125139153167181195209223237
BristolJim5NNewnn115294357718599113127141155169183197211225
BristolDave1NNewnn253953678195109123137151165179193207221235249
BristolMatt2NUsednn678195109123137151165179193207221235249263277291
BristolMatt3NUsedyy98112126140154168182196210224238252266280294308322
BristolMatt3YUsedyy8223650647892106120134148162176190204218232
BristolMatt5YUsedyy9233751657993107121135149163177191205219233
BristolMatt4YUsedyy7213549637791105119133147161175189203217231
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
50,530
Office Version
  1. 365
Platform
  1. Windows
You're welcome. Glad we could help. :)
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Forum statistics

Threads
1,141,075
Messages
5,704,162
Members
421,331
Latest member
imdumb

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top