Search results

I do not only need to lookup values but also delete the entire row that has that value. Unfortunately, it is thousands of rows as well.

Hello! I was wondering if would be possible to refer to a List in the second tab of a worksheet instead of including the specific numbers in the VBA as shown below. I have a long list of numbers that I need to put in this code: "If((@=76)+(@=77)+(@=82)+(@=85)" for a different workbook, there are...

I think it should look like this, but I am getting an issue of the property value ActiveSheet.PivotTables( ).PivotFields("W/E").AutoSort _ xlDescending, "W/E"

I want to add additional code to sort all the tables (table1-table6) in descending order of the date (the second column in the 2 column pivot table) How can I add this in? Sub SaveAsValues() Dim WS As Worksheet ActiveWorkbook.RefreshAll Set WkShts = Sheets(Array("Overview", "Sheet1"...

Thank you!

Thank you! this worked perfectly and I modified and used it for something else too!!!

I have a macro that saves the file in a specific drive location. However the drive is named differently on everyone's computer that has the network mapped (V vs X, et). So If I wanted to change this bit of macro to save in the same location as the original file which is always in the right...

I am trying to do a save as values in a copy of a report that I have. This works if I Dim as a worksheet, and it goes through all the worksheets. However, because I have pivot tables now in the first six tabs, this is no longer working. Instead I would like to do a save as values for 6...

I also want to add "<>East" to the "<>West" so either condition would take into effect. How can I change the VBA below? With Sht2 If .AutoFilterMode Then .AutoFilterMode = False .Range("A1").AutoFilter 5, 82 .Range("A1").AutoFilter 6, "<>West"...

I run the current macro in my report to keep all departments that are coded 76, 82 or 85. This macro takes out thousands of rows, which is perfect. Then I run another macro that adds department names based on a lookup list (not included). Now I need ta 3rd macro to go back and delete some more...

Hello friends! I am trying to combine the line 12 on the first page of multiple workbooks in multiple folders into one worksheet, so I can total the data from line 12 of each initial summary page. Also, I need the values only. The formula in A12 is ridiculous I don't know why they set it up...

:):)thank you---the second option works because it isn't that many (just one or two, but we must catch) but thank you for doing both types as I will most likely use each of the codes again in different situations. thnx!!!!:):)

In this sub, is it possible to make a message box to user to let them know what was "Not found" so they can add any missing items and run again? Sub Lookup() Dim Rng As Range Dim c As Range Dim result As String Set Rng = Range("c2:c" & Cells(Rows.Count...

thank you again!!

perfecto - thank you!

I am attaching a file that has sample info and the macro is in the module

I am uploading a sample file, also you will need to have both files open for the "command button" to work.

the code below works great with deleting columns not needed - but I also want to delete rows, and keep only ones where the Work Activity equals "76", "77", "82" or "85" Instructions: https://chandoo.org/forum/threads/posting-a-sample-workbook.451/ Sub DeleteColumnsRows() Dim Sht2 As...

Hello amazing people, I am learning so much, thank you - I have another question - how to I add a header name to each of these loops? altogether I am creating 4 columns but they don't have header names. Instructions: https://chandoo.org/forum/threads/posting-a-sample-workbook.451/ Sub...

yay thanks! don't know why I did it the way I did....o_O;)

I am attaching an example file hope it makes sense. I cleaned the data, the real file is more complicated than what I am showing, but I narrowed it down to that formula changing and the same issue comes up even with when I cleaned the data, it isn't what is appearing that is the issue - it is...

I have this formula and now that I am changing from PROPER(RIGHT(X25,LEN(X25)-10)) part to just PROPER(X25), it doesn't work old formula that works: =IFERROR(CHAR(149)&" "&IF(J25<>$J$13,TEXT(J25,"m/d/yy")&" ","")&PROPER(RIGHT(X25,LEN(X25)-10))&" - "&O25&" - "&PROPER(N25), "") new formula...

The code below creates folders in the right place, however, I also need to add a few more steps and I am not sure how to go about it. Based off the excel sheet, a folder needs to be created and sorted into the month folder indicated in the name in the cell value in Column R: Lastname Firstname...

Thank you - this is so helpful to learn. Also one more question, if I want this formula to only update when I add new rows in that have not had this formula run on them, and leave alone the ones that already have had this code ran on them (column n and o) - how do I change that?

Fluff, I get a an error saying there is a Next without For, at the Next C line