Search results

Not sure if this helps but I just noticed I have had better luck with adding macros and not having them disappear from alt F8 if I unhide the Personal.xlsb sheet and go into VB editor through altF8. If I access through the developer tab and Personal.xlsb is hidden, there is almost an 100%...

I finally was able to recreate the error. Debaser- When the macros are not showing, I cannot access the References option. It is not greyed out or anything. Just when I click it, it does nothing. When the macros are showing properly in Alt F8, however I am able to access the Tools References...

Thanks vletm and Debaser! Now of course when I build a macro, it works as expected. I will attempt the Debug-Compile as soon as I get it to malfunction again and see if that fixes it and report back. I followed some of the other suggestions for the google search that I will look into as well.

Sorry they do not show when All Open Workbooks are selected either

Yes. That is the one. I can still see them in the Developer tab but they disappear when I add a new macro or edit an existing one and save personal.xlsb. I doubt size is an issue but I checked and my personal.xlsb file is hovering around 450kb in size

Hi all- I have had this problem happen intermittently over the past couple of years but now it seems to happen almost every time I try to save a new macro to my personal file. I will insert a module in developer mode and paste the vba code in or manually record a macro. I will then save the...

Thanks for the response! Is there a formula for column F as well that column E can reference?

Hi all- I have been trying to find a solution for this but have come up empty. We have a new system that puts all of our barcodes into one cell in column C (example below) These values are dynamic. Some have 1 barcode and some have 15+. I am trying to find a way to use index match or...

So true. Wise words!

Thanks everyone! I tried everyone's recommendations but did not have any success so I restored a backup from last week. I was still able to access the current Personal file so I exported those to NotePad and was able to paste those into the restored Personal file so I lost minimal work...

Hi all! I have no idea what happened. I have used a version of my Personal.xlsb file for years and have over 200 macros saved to it. I was creating a new macro, made my changes like normal and saved the personal file as usual. It had the unique box to save the personal as it usually does...

Pasting into Notepad puts each entry into its own row for me but all in column A. 9161264 9180788 2 1 XYZ 123 ABC 3456 6 12

That works perfectly. Thanks so much for your help!!

Here is another file to show what it looks like with more than 2 entries that need to be separated

Uploaded. Sorry about that

Hello- I have looked all over but can't seem to find a solution to something that should be simple. I pull data from a PDF that looks like the following below. When pasting, it automatically puts all of the data in one cell separated by a line break. The data changes every time it is created...

That works perfectly! Thanks to all for their help!

In the Aggregate Result Columns D:F on the Output sheet, you'll see I included additional criteria in the formula. I had it checking A4, A5, A6 etc and to include that in the output of data as well. The problem that arises that if A4, A5, A6, etc is empty or blank, it returns incorrect data...

Nebu- Is there a way to account for blanks in Sheet2, Column A? I would need the formula to account for 30 rows sometimes for example. So this portion of the formula: (($A$2=Sheet1!$A$2:$A$13)+($A$3=Sheet1!$A$2:$A$13)) would need to be...

I have searched but not been able to find a solution anywhere. I'm assuming I have to use an array of some sort. I'm trying to simplify my data and still have it make sense. I essentially have two columns on one sheet (Sheet1). Column A is all months. COLUMN A COLUMN B JAN AB JAN...

This is so close to working! However, by changing the LastRow Code from "LastRow = Range("A2").End(xlDown).Row" to LastRow_A = Cells(Rows.Count, "A").End(xlUp).Row it now picks up and fills down to some summary formulas I have in cells A2500:2796. There are always blank cells between the data...

chirayu- Should I be adding that to the previous code of LastRow = Range("A2").End(xlDown).Row Range("B2:BS2").AutoFill Destination:=Range(Range("B2"), Range("BS" & LastRow + 1)) I tried to add it in and it just filled in column C down to the last row of formulas in row A. I am trying to...

Thanks for getting back to me, Chirayu and NARAYANK991! That was certainly easy to add the + 1 to the VBA. That fixes my first issue immediately For my second scenario, it does fill down from B2 where I was hoping for it to fill down from B10 to the last row plus one. Is there a way to...

I have a data that I paste in column A that is dynamic in quantity when I paste it in. Formulas are written into cells B2:BS2 I am familiar with the formula below to get the formulas to fill to the last row LastRow = Range("A2").End(xlDown).Row Range("B2:BS2").AutoFill...

That works perfectly. Thanks so much!!