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: 6
Default Check values in cells and replace them if they are the same value

Need some help to make a macro that check value in B3 against values in D3,
F3, H3 if any of the values are the same as in B3 it shall be replaced with
value in A3.

Then it shall go to B4 and do the same sheck With D4 , F4 and H4 untill it
reach the last entry inn B collone

Finn
 
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
How to check if the values in a range of cells are greater than 0 DP Excel Worksheet Functions 3 March 19th 10 01:31 PM
Copy and replace xlsm files, but retain the values in selected cells... ARbitOUR Excel Discussion (Misc queries) 1 April 24th 09 04:21 PM
check for FALSE values in a range of cells in VBA Dave F[_2_] Excel Discussion (Misc queries) 2 August 7th 07 04:12 PM
Replace values in shaded cells with blanks sue Excel Discussion (Misc queries) 3 January 11th 07 01:20 AM
Need formula to check values of data in several cells as criteria VCTECH Excel Worksheet Functions 0 November 19th 04 09:54 PM


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