Copy user mentioned column from first sheet to another mentioned column in second sheet

**rpatil** · 10-10-2012, 08:24 AM

Dear Friends,

Here is the problem statement:
I have the first data sheet called "data" which has multiple columns. I want to copy certain columns from this sheet to H1 and H2 depending upon the mapping provided in the mapping sheet.

If the mapping looks like:
From Data to H1
B A
then i want to copy the contents of column B from "data" sheet to column A of "H1" sheet

I have uploaded the excel doc on how the output should look like.

Would appreciate if someone can share macro/sample code/sample excel sheet on how to do this.

Regards
rpatil

**arlu1201** · 10-10-2012, 08:35 AM

In the mapping sheet, will your data always be in the middle of your sheet? Or will it be starting in A1?

If its in the middle of the sheet, it can make your code more cumbersome.

**rpatil** · 10-10-2012, 08:44 AM

HI Arlette

The mapping will start from A1.
There are 3 mappings and this is how it will look like

Cell A B C D E F
Data - H1 Data-H2 Data-H3

THis will be followed by number or column entries which needs to be copied from Data to H1/H2/H3

**arlu1201** · 10-10-2012, 08:53 AM

So just 6 columns in the mapping sheet right?

**rpatil** · 10-11-2012, 12:44 AM

Dear Arlette,

I have uploaded one more document - updated the sample document!
yes there willl be only 6 columns in the mapping file. But the thing is the entry in each column in data sheet will go upto 150-200 rows.
The entries in the mapping sheet also could go upto 100 entries.
so the idea is to copy the whole column to new sheets.

Really appreciate your help in this. I am very much a novice in this macro/vba and need this to be done for urgent and important purpose,
Thanks
Regards - rpatil

Copy user mentioned column from first sheet to another mentioned column in second sheet

LinkBack

Thread Tools

Rate This Thread

Display

Copy user mentioned column from first sheet to another mentioned column in second sheet

Re: Copy user mentioned column from first sheet to another mentioned column in second shee

Re: Copy user mentioned column from first sheet to another mentioned column in second shee

Re: Copy user mentioned column from first sheet to another mentioned column in second shee

Re: Copy user mentioned column from first sheet to another mentioned column in second shee

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions