Search results

Thanks @Marc L and @p45cal These are working great and are just what I needed. Thanks for your time on this, much appreciated.

Thanks Marc L I will try this out. Will this show any different result if column B's value contains a formula?

Remove both IF statements and replace with this single IF ?

Thanks @p45cal this appears to be doing just what I need. Thanks a lot for the help on this.

Thanks. I have attached a sample workbook. There are missing values in each sheet. I expect there will be plenty of duplicates in all sheets, but that's ok.

Thanks Marc L I updated the question with some detail.

Hi All - I have a workbook with approx 100 sheets. I want to be able to check every sheet that has data in Column A. If the adjacent cell in column B is blank, return the value from column A. (** If cell A5 has data, then B5 should have data. If B5 is blank, tell me what the value is in A5)...

Thanks all for your help. It did end up being the 'Range("A1:H" & LastRow)' that I overlooked.

Hi All - I am using the below code to combine a few steps on a sheet. The last part of the macro, I am trying apply a sort on column B but I am getting strange results. Some of my data is at the top of the sheet and the rest is several thousand lines down with all blank data in between. Not...

This is great info. Thanks to everyone else who gave solutions, I will try them all out.

You nailed it. That seems to account for the variations. Thank you so much ETAF

Ok, I see what you are saying there. I did look at some other data and noticed however it was formatted originally, they have the same as I gave you, but with single digit month (2 instead of 02). The rest of the data is the same.

Does the first "LEFT(A1,2)" change to (LEFT(A1,1) if there is only single digit month?

That did the trick... I really need to learn more about this kind of formula. Thanks so much for your help on this :)

Ah ok I see how that is working. I am in the US, so I use MM/DD/YYYY

Hmm this is very strange. I cannot get it to work. I deleted and downloaded the one you just sent and it does the same thing.

I am using Excel 365 but I will try the text on it and see if that works.

Thanks @ETAF It shows #Value error in the cell on your attachment. Not sure what is causing that.

Hi All - I have a string that is being used as a serial number which is just created from the date/time. Does anyone know how I can convert this back to date & time? Into format 02/15/2023 12:25:00 PM I have tried using custom formats etc but nothing has worked. Thanks for any help...

Hi All - I am using this code to print all items from a listbox that come from searching multiple files for a string. Once the listbox populates, I have an image load that goes with the search. How can I include the image with what prints out? Private Sub PrintList_Click() With...

Thanks for this detailed explanation BobBridges, much appreciated. At the moment, I am wanting to do this just one cell at a time only for the reason that if a person stops in the middle, then I can't tell what range to append when they come back to scanning the barcodes. Right now I am using...

Hi All, I have a column that is populated from scanning barcodes. After each barcode is scanned, the text is entered into the cell and moving down one cell. How can I get that value so I can append it to a text file? The scanned items are not always in numerical order by row, which is why I...

BobBridges... thanks a lot for your help on this, much appreciated. I was able to get this to work after seeing your reply. I was missing the arguments (DOH!). Its working great now.

Hi All - I am using this code to basically re-write a range in Column A to a text file. My requirements have now changed to where I need to append to the text file with the current cell in Column A rather than re-writing the entire range. For example, I have the users scanning barcoded part...

Thanks for your help @pecoflyer ... I am getting a 'Too few arguments' error when applying it.