Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell insertion if values not matching
It seems like you are talking about rows and columns as if they are the same
thing (but of course they are not). Try to run this function and see if it gives you what you want: Sub InsertAfterTextChange() Do Until ActiveCell = Empty And ActiveCell.Offset(1) = Empty If ActiveCell < ActiveCell.Offset(1) And ActiveCell < Empty And ActiveCell.Offset(1) < Empty Then ActiveCell.Offset(1).EntireRow.Insert ActiveCell.Offset(2).Select Else ActiveCell.Offset(1).Select End If Loop End Sub Make sure you have a backup of your data in case the code does not do what you want. Finally, make sure your data is sorted in order (ascending or descending) in Column A. Regards, Ryan--- -- RyGuy "Susan" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell insertion if values not matching
My mistake, I should have written coloumn A, B,C etc.
I'm new at this, so forgive me if I ask what I should already know. How do I establish the active cell and the active cell offset? What in this formula should I be changing. Here is what I need. IE: If C2 = B2, No Action . . . If C2 < B2, insert cells in C2:I2 (not an entire row) Continued thru row 414. Susan -- Thanks! Susan "ryguy7272" wrote: It seems like you are talking about rows and columns as if they are the same thing (but of course they are not). Try to run this function and see if it gives you what you want: Sub InsertAfterTextChange() Do Until ActiveCell = Empty And ActiveCell.Offset(1) = Empty If ActiveCell < ActiveCell.Offset(1) And ActiveCell < Empty And ActiveCell.Offset(1) < Empty Then ActiveCell.Offset(1).EntireRow.Insert ActiveCell.Offset(2).Select Else ActiveCell.Offset(1).Select End If Loop End Sub Make sure you have a backup of your data in case the code does not do what you want. Finally, make sure your data is sorted in order (ascending or descending) in Column A. Regards, Ryan--- -- RyGuy "Susan" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Position insertion point at beginning of cell when editing | Excel Discussion (Misc queries) | |||
Finding Most Recent Values in Col1 -- Summing Matching Values | Excel Discussion (Misc queries) | |||
find a cell matching separate column and row values | Excel Worksheet Functions | |||
Using a Cell Operation for insertion into a Formula | Excel Discussion (Misc queries) | |||
Matching data and linking it to the matching cell | Links and Linking in Excel |