• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. H

    VBA to pull data dynamically from multiple sheets

    Hello All, I have a created a spreadsheet for our sales team. There are five sales staff and I have assigned each with one tab so they can update their sales data which occurs several times a day. I want excel to dynamically pull data from each tab and when it goes to last row for a particular...
  2. H

    VBA Macro To Prevent Saving Without Filling Mandatory Fields

    Hello Nebu, Here is my final code that select All Worksheets but I want my code to apply to select sheets i.e. Sheets 01 to 26. Function cCheck() As Boolean If ActiveSheet.Range("R1").Value = True Then cCheck = False Else cCheck = True MsgBox "Warning:" & vbCrLf & "Select CHECK BOX...
  3. H

    VBA Macro To Prevent Saving Without Filling Mandatory Fields

    Hello there, I have an Excel Workbook. It has 26 Sheets. Each Sheet represents Two Week Pay Period. I have put a Checkbox (Check Box 37). I want a macro that would prevent users from SAVING the Workbook without checking the Checkbox. Also, I want macro to prompt ONLY for the Active Worksheet...
  4. H

    Excel Automating Conditional Formatting

    Hello Forum Friends, I need your help in conditional formatting in Excel. I have two spreadsheets (sheet 1 and 2). My users update the sheet 1 and my conditional formatting is working fine in it. However, for sheet 2 which I linked to sheet 1 using vlookup formula, although values are changed...
Back
Top