Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Compare two wk sheets with common data using copy paste macro

Howdy, I have XP Home version but have installed Micro 97', Please help in,
I work off two different workbk's, which both contain basicaly same data,
they are both part number specific in Col A(cell A2) sht 1 and sht 2 and On
Hand specific in Col B (cell B2) sht 1 and sht2 but rows differ from day to
day. This what I'm after.
A Macro that will compare Col A sht1 and Col A sht2 and if can't find in Col
A (Cell A2) sht2 will highlight BOLD in sht1 Col A cell A2 and down the line.

Please Help ASAP!




--
Thank You!

conejo
Reply
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
Data from diff sheets to one common sheet Ross Excel Worksheet Functions 4 August 7th 07 01:19 AM
how to compare two columns on two sheets and copy associated data from one sheet to the other? [email protected] Excel Worksheet Functions 2 June 22nd 07 03:40 PM
macro needed to compare value and copy data underneath it to anoth Arain Excel Discussion (Misc queries) 1 April 17th 07 10:52 PM
Compare two Sheets and copy value sa02000 Excel Worksheet Functions 1 May 3rd 06 01:51 PM
Compare multiple column of data and list out common and unique component in adj columns kuansheng Excel Worksheet Functions 15 February 1st 06 10:49 PM


All times are GMT +1. The time now is 04:43 AM.

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

About Us

"It's about Microsoft Excel"