Find excel column and copy to other sheet

knaabis

Active Member
Joined
Apr 25, 2006
Messages
254
Office Version
  1. 2013
Platform
  1. Windows
I need to find by title some columns in one sheet and copy these columns one after the other to other sheet.
How to made by VBA?
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Can you give more details?
What titles are you looking for?
What are your sheet names?
Are you copying them to the exact same column on the other sheet (if not, there how to determine which column to paste to)?
 
Upvote 0
<style type="text/css">
table.tableizer-table {border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif; font-size: 12px;} .tableizer-table td {padding: 4px; margin: 3px; border: 1px solid #ccc;}
.tableizer-table th {background-color: #104E8B; color: #FFF; font-weight: bold;}
</style>

<table class="tableizer-table">
<tr class="tableizer-firstrow"><th>Prod. Order No.</th><th>Item No.</th><th>Item Name</th><th>Quantity</th><th>Starting Date</th><th>Ending Date</th><th>Finished Date</th><th>Status</th><th>Outst. Quantity</th><th>Start Week</th></tr> <tr><td>O00014</td><td> </td><td> </td><td>0</td><td>04.04.2011</td><td>04.04.2011</td><td> </td><td> </td><td>0</td><td>14</td></tr> <tr><td>11-S01</td><td>37-0031-82-000</td><td>aaaaa</td><td>1</td><td>28.06.2011</td><td>29.06.2011</td><td> </td><td> </td><td>1</td><td>26</td></tr> <tr><td>11-S02</td><td>37-0001-32-12A</td><td>bbbbb</td><td>1</td><td>28.06.2011</td><td>29.06.2011</td><td> </td><td> </td><td>1</td><td>26</td></tr> <tr><td>11-S03</td><td>36-4274-01-000</td><td>ccccc</td><td>1</td><td>28.06.2011</td><td>29.06.2011</td><td> </td><td> </td><td>1</td><td>26</td></tr> <tr><td>11-S04</td><td>36-4276-01-000</td><td>ddddd</td><td>1</td><td>28.06.2011</td><td>29.06.2011</td><td> </td><td> </td><td>1</td><td>26</td></tr> <tr><td>11-TEX158</td><td>36-4703-BG-000</td><td>eeeee</td><td>10</td><td>02.03.2011</td><td>04.03.2011</td><td>07.03.2011</td><td>Finished</td><td>0</td><td>9</td></tr></table>

For example table like this and i need to copy to other sheet columns with title - Prod. Order No., Item No., Ending Date, Status.
.
,
,
 
Upvote 0
The easiest thing to do might be to copy the whole table over, then delete the columns you do not need.
If you use the Macro Recorder, you should be able to record most of the code you need to do this.
If you need help cleaning up the code afterwards, or adding things to it, post the code you have here with your request.
 
Upvote 0

Forum statistics

Threads
1,213,544
Messages
6,114,249
Members
448,556
Latest member
peterhess2002

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
Back
Top