LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 87
Default Macro to copy columns from 1st sheet to 2nd according to mapping-p

This one is somewhat difficult. I have two different workbooks. In first
workbook I have 10 columns (say) and in the second, I have more (or also less
in some cases) columns than the first, let us assume 15.

Now I have to map parameters of both the sheets. I want to design a form
which will show column names of both the sheets and I will choose the
mapping. means I will define there which parameter in first sheet is to be
mapped to which parametr in second sheet. After doing this, the macro should
copy the contents of 1st column (except title) to the second column.

The second sheet will be always blank with all columns having titles.

e.g. I have sheet 1 with columns A to J and I ahve sheet 2 with columns A to
O. The form will show TITLES (like 'school name' and not column names like
A,B,...)of columns and I will map corresponding columns (How to do that in
form, I don't know). Then contents from first sheet to second sheet will get
copied according to mapping. means if A (with title 'school name') is mapped
to E (with title 'institute name'), then contents of A will be cpoied to
column E with title remaing the same ('institute name').

This problem seems to be difficult, but I will be very thankful to whoever
will do it. It will save a lot of time...
Thank You...
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
mapping? columns from one excel workbook to another Jadooi Excel Discussion (Misc queries) 1 December 12th 09 01:08 AM
Multi-sheet mapping problem Titanus Excel Worksheet Functions 1 April 10th 06 04:31 AM
Using Excel's XML mapping/export with data organized in columns DaveWhatmuff Excel Worksheet Functions 0 June 16th 05 06:53 PM
macro to copy columns to sheet Es Excel Discussion (Misc queries) 1 March 7th 05 02:03 PM
column mapping from on sheet to the next HansM Excel Discussion (Misc queries) 1 March 7th 05 01:54 PM


All times are GMT +1. The time now is 09:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"