LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 49
Default compare and copy

well i have a situation at my hand
i have two sheets. one has a list of 2000 item and the other has 375
i want to compare the sheetA 375 one with SheetB 2000.
if the column A matches the columnA of sheet2 then copy the values from
sheetB from column B thru F in to sheet A F thru L can someone please tell
me how to do this or if someone can write a macro for this as i dont know at
all how to write those macros
 
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
Compare and copy unique values sa02000 Excel Worksheet Functions 1 June 12th 06 09:42 PM
Compare name and copy from closed .csv files Mikke Excel Worksheet Functions 0 May 12th 06 11:49 PM
Compare two Sheets and copy value sa02000 Excel Worksheet Functions 1 May 3rd 06 01:51 PM
Compare and copy AJM1949 Excel Discussion (Misc queries) 2 April 6th 06 07:07 AM
Compare and copy Mary Excel Worksheet Functions 2 January 24th 06 04:22 AM


All times are GMT +1. The time now is 03:25 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"