LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 271
Default Cell insertion if values not matching

Thanks in advance for your help!

I have created a spreadsheet to inventory equipment that have GPS units -

I need help in working through some formatting or Macro, ???

I have placed my master equipment listing in Row B
The exported GPS listing Equipment number in Row C
If they match - Row A has conditional formatting to indicate color Green &
'Verified'

What I need is if they do not match -
If row C row B, insert blank cells in row on columns C,D, & E and shift
cells down to continue the verification process thru the entire 400 piece
listing.

--
Thanks!
Susan
 
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
Position insertion point at beginning of cell when editing Sue Excel Discussion (Misc queries) 9 March 28th 08 05:37 PM
Finding Most Recent Values in Col1 -- Summing Matching Values Rothman Excel Discussion (Misc queries) 5 December 20th 07 08:19 PM
find a cell matching separate column and row values LQEngineer Excel Worksheet Functions 2 July 26th 06 07:10 AM
Using a Cell Operation for insertion into a Formula JCary Excel Discussion (Misc queries) 1 March 4th 06 12:22 AM
Matching data and linking it to the matching cell yvonne a via OfficeKB.com Links and Linking in Excel 0 July 13th 05 07:30 PM


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