1. D

    Help me understand my VBA code please (easy) - thanks!

    Hello everybody, I am currently managing a stock (inventory management) portfolio in Excel. In this, I have my current inventory quantity in column I and two columns in column J & K which I can use to subtract & add amounts from my quantity, so: Column I = Current quantity Column J = Enter any...
  2. M

    Match formula to exclude criteria

    Hello! Wondering if could have feedback on writing a formula that excludes specific criteria from a list. I started a formula that saysIF(ISERROR(MATCH(cellA1,lookupcolumn,0))=FALSE. I’m confused by ISERROR. That essentially returns true if there is an error or false? I want to write a formula...
  3. CsJHUN

    VBA slideshow-ish

    Hi guys i would like to create a userform, which load pictures from a folder, and change the pictures every 3-4 seconds, while the user can select between 2 option button ( good or not good). And the picture name,the selected option button value would be registered below each other. The 'sleep'...
  4. V

    Save file as folder name/sheets as file name

    Hi I would like to change this code to save the file as the folders name instead of "Total Results.xlsm" Also I'm trying to name the worksheets the same as the files that its importing instead of "Data" & i +1 Thanks a lot to anyone that can help Sub ImportCSVData() Dim wb As Workbook Dim...
  5. S

    VBA help to copy rows when key words are selected

    Hello, I use the below code to transfer rows from the "LOG" Tab to the "RTN HISTORY" tab when "SCRAP", or "RELEASED" in Col Z is selected from the drop down. My question is how would I have it transfer back to the LOG tab if "HOLD" is selected from the dropdown? Thanks for all...
  6. T

    Len() function

    Private Sub Form_BeforeUpdate(Cancel As Integer) Dim strMissingInfo As String Dim strMsg As String If IsNull(Me.[Debarred]) Then Cancel = True strMissingInfo = strMissingInfo & "Debarred" End If If IsNull(Me.[Restricted]) Then Cancel = True...
  7. G

    Optimize VBA copy/paste

    Hey guys, I am basically trying to make my code run faster, I am trying to convert a section of the code that copies and pastes data across two workbooks to be faster and cleaner. Here is the original paste/copy data: Sub WALLCERTIFICATE()' ' Macro2 Macro ' Dim M As Workbook Set M =...
  8. L

    CountIf True

    =COUNTIF(Data[Column1],TRUE) I have the above mention formula but i want to modify it to add that if Counts of Assets in BU is blank dont count the true now is counting 1,221 but it should be 1177
  9. S

    Slight alteration to VBA code for renaming sheets

    Hi - hoping someone better than me can help with a slight adjustment to the below code. I think its easy for someone with the skills. So it currently opens all the files in a picked folder and renames the sheet to Sheet1, so long as there's only one sheet. Problem is I have a combination of...
  10. L


    =SUMPRODUCT((Raw Data[Count of Assets in BU)*(Raw Data[Column1]=TRUE)) Something is wrong with the formula, what i need is to place the formula in the calculation tab that if header Column1 is true, sum the header Count of Assets in BU that meet the true criteria
  11. B

    Entering a date stamp if a value in cell is True

    Hello everyone, Couldnt seem to find the correct formula for what I am trying to do. In Column O There will be a Yes or a No depending on Checkbox selection on userform. Say cell O2 is entered or changed to true then I want cell P2 to have a non changing date stamp. here is a screen shot of...
  12. T

    VBA: Is there any way to "make all items visible" in a PivotTable Field?

    I recorded a macro by going to a PivotTable, and in the dropdown for the field i was interested in, i checked "Select all)" and then pressed OK. What VBA recorded was this: With ActiveSheet.PivotTables("PivotTable3").PivotFields("Vaca") .PivotItems("excl").Visible = True...
  13. B

    Search for multiple text within a cell and return text

    I'm trying to do multiple text searches in a cell and return text if true. If not true then I want the cell to be blank. For example Column A is PaymentNotFound12345 and I want the formula in column B to search for "PaymentNot" and return "PaymentNot". However I need to also search for other...
  14. T

    Call Command Looks For Sheet & If Not found End Sub

    Hi all, I am after some help, I use the following code to call a sheet and then produce it as a PDF, then it sets up the email ready to send - this is setup for 200 sheets and rather than make the button call up on active sheets where I have not used ' to negate the call. Is there a way of...
  15. W

    Struggling with nested functions

    Can someone please help me to write the following formula? Conditions: if A1 and B2 are blank and A2 and B1 are NOT blank If True: = A2 If False: (leave cell blank)
  16. C

    Make macro work with upper case and lower case

    Hello! I have the following Macro (below) in a spreadsheet I use to record work times for my employees. In column C there is a dropdown in which they are supposed to choose "ARRIVED," and then a timestamp appears in both column D and P. Similar for column E - they're supposed to select...
  17. M

    Count the number of "TRUE" cells in an adjacent field in a table?

    I have an Excel table with a field called TradingDay that simply stores Boolean values of whether a given date is a trading day. I used the formula described here to get whether the date is a trading day or not: Now I want to create a new field...
  18. willow1985

    Help with COUNTIF / OR formula and SUMIF / OR formula

    I need help with a formula or possibly another way to figuring out this problem: I want to count everything in 'WO Report'!$Y:$Y that states: TRUE Only IF 'WO Report'!B:B Matches List!B2 However only if there is no match between 'WO Report'!B:B and List!B2 I want to count everything in...
  19. T

    How to change code to and

    Private Sub Command43_Click() 'Admin Button Bring back nav and other views that are hidden If Text9.Value = "tam.badal" Then 'UnHide the hidden objects in the navigation pane Application.SetOption "Show Hidden Objects", True 'UnLock navigation pane...
  20. Nelson78

    Regex: hidden "" after a substitution

    Hello everybody. I've a cell assuming different values. For example: 105,32 euro Now, with regex I've removed the non numeric value in order to have 105,32 My code: Dim replacement As Object, trunc As String Set replacement = CreateObject("vbscript.regexp")...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back