LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Miriam
 
Posts: n/a
Default How do I copy columns between worksheets if the columns don't matc

I have 2 worksheets in which I have to copy one column of cells from one to
the other. The problem is that the "main" worksheet lists nearly 3,500
clients and I have to copy numbers into the "main" worksheet on weekly basis
from another worksheet that lists only about 1,100 of those 3,500 clients.
Both client lists are in alphabetical order, but I obviously cannot just copy
one column into the other, because then the numbers won't be matching the
correct clients.
 
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
Same info from one column to different columns in multiple worksheets B_K Excel Discussion (Misc queries) 5 April 27th 06 12:31 AM
Copy worksheet & maintain cell reference across worksheets dingy101 Excel Worksheet Functions 3 January 2nd 06 10:51 AM
How do I copy a worksheet's print parameters to other worksheets? Redundant908 Excel Worksheet Functions 2 December 6th 05 11:17 PM
using programming to copy worksheets data only maxzsim Excel Discussion (Misc queries) 1 November 29th 05 05:02 PM
Copy worksheets and formats Ken Excel Discussion (Misc queries) 1 January 31st 05 12:00 AM


All times are GMT +1. The time now is 07:39 PM.

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"