Posts by Stanley D. Grom

Re: How to count consecutive numbers based on the first number of the column

Cross Posted here:

https://www.mrexcel.com/forum/…-first-number-column.html

[TABLE="width: 64"]

[TD="width: 64, bgcolor: transparent"]A message to forum cross posters.[/TD]

[TD="bgcolor: transparent"][/TD]

[TD="bgcolor: transparent"]Please read this:[/TD]

[TD="bgcolor: transparent"]http://www.excelguru.ca/node/7[/TD]

[/TABLE]

Re: Compare list to master list (text) and insert rows in place of missing items

A message to forum cross posters.

Please read this:

http://www.excelguru.ca/node/7

Re: Transpose comma delimitted cell to multiple rows and copy adjacent cell down

rusted314,

Sorry for the late reply.

Welcome to the Ozgrid forum.

1. What version of Excel and Windows are you using?

2. Are you using a PC or a Mac?

To get the most precise answer, it is best to upload/attach a sample workbook (sensitive data scrubbed/removed/changed) that contains an example of your raw data on one worksheet, and on another worksheet your desired results.

The structure and data types of the sample workbook must exactly duplicate the real workbook. Include a clear and explicit explanation of your requirements.

To attach your workbook, scroll down and click on the Go Advanced button, then scroll down and click on the Manage Attachments button.

Re: VBA for deleting rows if cell in range are blank

minvai,

Thanks for the feedback.

You are very welcome. Glad I could help.

And, come back anytime.

Re: VBA for deleting rows if cell in range are blank

minvai,

Are you sure that there are cells in range B12:B38 that are BLANK?

Your code does work for me in my test environment.

Try the following macro.
Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

1. Copy the below code
2. Open your NEW workbook
3. Press the keys ALT + F11 to open the Visual Basic Editor
4. Press the keys ALT + I to activate the Insert menu
5. Press Mto insert a Standard Module
6. Where the cursor is flashing, paste the code
7. Press the keys ALT + Q to exit the Editor, and return to Excel
8. To run the macro from Excel press ALT + F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

Sub Delete_B12B38_BlankCells_Rows()
' Stanley D. Grom, 07/18/2014, OZ189735
On Error Resume Next
Range("B12:B38").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
On Error GoTo 0
End Sub

Before you use the macro with Excel 2007 or newer, save your workbook, Save As, a macro enabled workbook with the file extension .xlsm

Then run the Delete_B12B38_BlankCells_Rows macro.

Re: search colum D for match if found copy cell next to match(E#) to next vacant cell

SquishingtonIII,

Thanks for the feedback.

You are very welcome. Glad I could help.

And, come back anytime.

Re: search colum D for match if found copy cell next to match(E#) to next vacant cell

SquishingtonIII,

With your raw data in worksheet Sheet1, and, grouped/sorted by column D Email.

Detach/open workbook ReorgDataV2 groups colD colE to colF - SquishingtonIII - OZ189502 - SDG15.xlsm and run the ReorgDataV2 macro.

Re: search colum D for match if found copy cell next to match(E#) to next vacant cell

SquishingtonIII,

With your raw data in worksheet Sheet1, and, grouped/sorted by column D Email.

Detach/open workbook ReorgData groups colD colE to colF - SquishingtonIII - OZ189502 - SDG15.xlsm and run the ReorgData macro.

Re: Arranging Data from two different columns to One column with multiple subtitle

Cross posted here:

http://www.mrexcel.com/forum/e…-formula.html#post3843936

And, here:

http://www.excelforum.com/exce…-subheadings-formula.html

[TABLE="width: 89"]

A message to forum cross posters

Please read this

http://www.excelguru.ca/node/7

[/TABLE]

Re: Table of same cells from many worksheets

cooksterni,

You can upload your workbook to http://www.box.net

sensitive data changed

mark the workbook for sharing

and provide us with a link to your workbook.

Re: Table of same cells from many worksheets

cooksterni,

Welcome to the Ozgrid forum.

1. What version of Excel and Windows are you using?

2. Are you using a PC or a Mac?

To get the most precise answer, it is best to upload/attach a sample workbook (sensitive data scrubbed/removed/changed) that contains an example of your raw data on one worksheet, and on another worksheet your desired results.

The structure and data types of the sample workbook must exactly duplicate the real workbook. Include a clear and explicit explanation of your requirements.

To attach your workbook, scroll down and click on the Go Advanced button, then scroll down and click on the Manage Attachments button.

Re: help to use wild card to compare two columns on two sheets and highlight cells

kbotta,

Quote

I have determined that the code you provided does indeed work.

Thanks for the feedback.

You are very welcome. Glad I could help.

And, come back anytime.

Re: help to use wild card to compare two columns on two sheets and highlight cells

kbotta,

Thanks for the workbook.

Quote

If you look in row 43 (COMBINED SHEET) I have highlighted it in Yellow.

The value in cell B43 is 1150227

The macro searches for 1150227* , and, thereby does not color cell RED, because it is found

It does exist in Sheet2 cell A1703 = 1150227-rB.pdf

Re: help to use wild card to compare two columns on two sheets and highlight cells

kbotta,

Quote

It works great with one exception:
It is "finding" the same part number in column B and not turning it red. I want to only search Column S for the comparison. So if cell value in Column B exists in Column S - it does not turn red.
Right now it is finding another cell value in Column B.
It is very close!

Where in your relies have you included/discussed column S?

In order to continue, please attach the same workbook (manually formatted by you) with the cells that should be colored RED.

If you are not able to supply the above, then:

In the Quick Reply box, just put the word BUMP. Then, click on the Post Quick Reply button, and someone else will assist you.

Re: help to use wild card to compare two columns on two sheets and highlight cells

kbotta,

Let's see if this will work again.

Detach/open Compare_Combined_colB_Sheet2_colA rngobjects - kbotta - OZ188799 - SDG15.xlsm and run the Compare_Combined_colB_Sheet2_colA macro.

NOT working?????

Re: help to use wild card to compare two columns on two sheets and highlight cells

kbotta,

Detach/open Compare_Combined_colB_Sheet2_colA rngobjects - kbotta - OZ188799 - SDG15.xlsm and run the Compare_Combined_colB_Sheet2_colA macro.

I am not able to add/upload a new file.

Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

1. Copy the below code
2. Open your NEW workbook
3. Press the keys ALT + F11 to open the Visual Basic Editor
4. Press the keys ALT + I to activate the Insert menu
5. Press M to insert a Standard Module
6. Where the cursor is flashing, paste the code
7. Press the keys ALT + Q to exit the Editor, and return to Excel
8. To run the macro from Excel press ALT + F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

Sub Compare_Combined_colB_Sheet2_colA()
' Stanley D. Grom, 06/05/2014, OZ188799
Dim wc As Worksheet, w2 As Worksheet
Dim c As Range, arng As Range
Application.ScreenUpdating = False
Set wc = Sheets("Combined")
Set w2 = Sheets("Sheet2")
With wc
  For Each c In .Range("B2", .Range("B" & Rows.Count).End(xlUp))
    Set arng = w2.Columns(1).Find(c & "*", LookAt:=xlWhole)
    If arng Is Nothing Then
      c.Interior.Color = vbRed
    End If
    Set arng = Nothing
  Next c
End With
Application.ScreenUpdating = True
End Sub

Before you use the macro with Excel 2007 or newer, save your workbook, Save As, a macro enabled workbook with the file extension .xlsm

Then run the Compare_Combined_colB_Sheet2_colA macro.

Re: help to use wild card to compare two columns on two sheets and highlight cells

kbotta,

In sheet Combined, cell B2 contains 5.9065.10.020.4

There is a match in Sheet2, cell A458 contains 5.9065.10.020.4-rA.pdf

1. When there is a MATCH like above, does B2's Interior.Color get changed to RED?

2. Or, when there is NO MATCH, does the Interior.Color get changed to RED?

Re: help to use wild card to compare two columns on two sheets and highlight cells

kbotta,

In sheet Combined, cell B2 contains 5.9065.10.020.4

There is a match in Sheet2, cell A458 contains 5.9065.10.020.4-rA.pdf

1. When there is a MATCH like above, does B2's Interior.Color get changed to RED?

2. Or, when there is NO MATCH, does the Interior.Color get changed to RED?

Re: help to use wild card to compare two columns on two sheets and highlight cells

kbotta,

1. What version of Excel are you using?

2. Are you using a PC or a Mac?

Re: help to use wild card to compare two columns on two sheets and highlight cells

kbotta,

You can upload your workbook to Box Net,

sensitive data changed

mark the workbook for sharing

and provide us with a link to your workbook.