dcsimg

Search:

Type: Posts; User: Nish12

Page 1 of 2 1 2

Search: Search took 0.04 seconds.

  1. Re: Combing Multiple Excel Worksheets onto One Worksheet Based on Check Box Selection

    My above comment is referring to the below code:

    Dim s As Worksheet, rng As Range, dest As Worksheet
    Set dest = Sheets("Consolidated invoice")
    For ch = 1 To 4
    Set s = Sheets("intake form")
    ...
  2. Re: Combing Multiple Excel Worksheets onto One Worksheet Based on Check Box Selection

    Referring to this code in my above comment:
    Dim s As Worksheet, rng As Range, dest As Worksheet
    Set dest = Sheets("Consolidated invoice")
    For ch = 1 To 4
    Set s = Sheets("intake form")
    With...
  3. Re: Combing Multiple Excel Worksheets onto One Worksheet Based on Check Box Selection

    Will the above code work if I have more than 5 buttons? Lets say I have 20 buttons. Do I just update "For ch = 1 To 4" to "For ch = 1 To 20"?

    When I add checkboxes they sometimes don't...
  4. Re: Combing Multiple Excel Worksheets onto One Worksheet Based on Check Box Selection

    Sub Printtopdf()

    Dim r As Range, s As Worksheet, fnd As Range
    Set s = Sheets("Pricing Proposal")
    Set r = s.Range("C2").Resize(, 4)
    Set r = r.Resize(s.Cells(Rows.Count, r.Column).End(xlUp).Row -...
  5. Re: Combing Multiple Excel Worksheets onto One Worksheet Based on Check Box Selection

    I agree. Can you help me decipher the below so I know what number to put in? What resources do you recommend for learning VBA? I'm just googling as I go. I'll spend more time looking at the...
  6. Re: Combing Multiple Excel Worksheets onto One Worksheet Based on Check Box Selection

    In the attached sample file, all of my products are named Product A, Product B, Product C. What if that wasn't the case and my products all had unique names like. Product A, Combination B, Package...
  7. Re: Combing Multiple Excel Worksheets onto One Worksheet Based on Check Box Selection

    In the attached sample file, all of my products are named Product A, Product B, Product C. What if that wasn't the case and my products all had unique names like. Product A, Combination B, Package...
  8. Re: Combing Multiple Excel Worksheets onto One Worksheet Based on Check Box Selection

    Are you able to apply this code to the file I shared with you earlier so I know how it works? Since I'm so new to VBA code, I may not understand how the row and column references are working and...
  9. Re: Combing Multiple Excel Worksheets onto One Worksheet Based on Check Box Selection

    Hi Westconn1,

    I've read through your message and tried to incorporate it into my updated code shown below. But am having no luck. When I included the s.activate before s.Parent.Windows(1).View =...
  10. Re: Combing Multiple Excel Worksheets onto One Worksheet Based on Check Box Selection

    Forgot to mention that my PrinttoPDF macro is assigned to a button on the Deal Input tab. I didn't want my button to be displayed on the printed sheet (Consolidated Invoice/Pricing Proposal) as it...
  11. Re: Combing Multiple Excel Worksheets onto One Worksheet Based on Check Box Selection

    Hi Westconn1,

    I tested the below code and the page breaks didn't adjust on the Pricing Proposal page. The page break command looks like it was applied on the Deal Input Form where the check box...
  12. Re: Combing Multiple Excel Worksheets onto One Worksheet Based on Check Box Selection

    Thanks so much for your quick response!

    So when I enter this vba code into my file, I get an Run Time Error '9': Subscript out of range and the below line is highlighted in yellow:

    Set r =...
  13. Re: Combing Multiple Excel Worksheets onto One Worksheet Based on Check Box Selection

    So I got the print to PDF to work out great, by replacing the printer name as suggested :)

    I've also checked out the code on the page break. How do I combine the Print to PDF vba code with the...
  14. Re: Combing Multiple Excel Worksheets onto One Worksheet Based on Check Box Selection

    I got the PDF to work :) Thanks for sharing the link, will take a look.
  15. Re: Combing Multiple Excel Worksheets onto One Worksheet Based on Check Box Selection

    Thanks! How would I adjust your code above to have it print to PDF on my screen?
  16. Re: Combing Multiple Excel Worksheets onto One Worksheet Based on Check Box Selection

    How would I adjust the above code to print to PDF on my screen? I can then save to a location on my computer.

    So my goal is to have the consolidated invoice page populated with all of the pricing...
  17. Re: Combing Multiple Excel Worksheets onto One Worksheet Based on Check Box Selection

    Not a problem, you have been a great help. I started from scratch and it worked. Must have been something in my file, not sure...
  18. Re: Combing Multiple Excel Worksheets onto One Worksheet Based on Check Box Selection

    For some reason, when I try to execute the above code in my workbook. I get an error message that states: "Run Time Error: 1004: Copy method of Range class failed."

    The below line is then...
  19. Re: Combing Multiple Excel Worksheets onto One Worksheet Based on Check Box Selection

    Thank you, I will test!
  20. Re: Combing Multiple Excel Worksheets onto One Worksheet Based on Check Box Selection

    Thank you, yes, I figured out the issue and had to rename the checkboxes.

    Could you please help me with the VBA code to do a print to PDF while making sure the margins adjust to the print area...
  21. Re: Combing Multiple Excel Worksheets onto One Worksheet Based on Check Box Selection

    Do you know why I get the below error message when I try to execute the code in my workbook?

    Run-time error '-2147024809 (80070057)': The item with the specified name wasn't found.


    When I...
  22. Re: Combing Multiple Excel Worksheets onto One Worksheet Based on Check Box Selection

    how does the code know to get the data that is on the Product A tab by just clicking on the Product A checkbox? Is the code dependent on the tab name matching the check box name?
  23. Re: Combing Multiple Excel Worksheets onto One Worksheet Based on Check Box Selection

    Also, are you able to break down line by line what the vba code is doing so I can understand how to incorporate this to my actual data? This is really brilliant and I am so grateful for your help.
  24. Re: Combing Multiple Excel Worksheets onto One Worksheet Based on Check Box Selection

    Beautiful thanks!! Is it pretty easy to do a print to PDF of the end result, the consolidated invoice tab? How do I make sure the print area of the consolidated invoice captures all of the results?
  25. Re: Goal Seek Macro Giving 400 Error or Compile Error: Invalid or Unqualified Referen

    Actually I figured it out. The changing cell had to have a value in it for the macro to run. I just input a dummy amount of $1.00 in there and when I ran the macro it then worked. Leaving the...
  26. Re: Goal Seek Macro Giving 400 Error or Compile Error: Invalid or Unqualified Referen

    Correction to my code shown above:

    Sub GoalSeek()

    Range("AC3").GoalSeek Goal:=Range("X3").Value, ChangingCell:=Range("Y9")

    End Sub

    When I run this, I now get Run time error '1004':
  27. Goal Seek Macro Giving 400 Error or Compile Error: Invalid or Unqualified Reference

    Hi,

    I'm using the below vba code to run a Goal Seek macro in my excel file. AC3 is a formula which is calculating a gross margin % (gross margin/revenue), X3 is the gross margin % I want it to...
  28. Re: Combing Multiple Excel Worksheets onto One Worksheet Based on Check Box Selection

    Could you help show me how to do this using the sample file I provided?
  29. Re: Combing Multiple Excel Worksheets onto One Worksheet Based on Check Box Selection

    Hi Westconn1,

    I tried to do as suggested by copying your code under the View Code on the Consolidated Invoice tab but nothing happened. Please let me know if I am supposed to do something...
  30. Combing Multiple Excel Worksheets onto One Worksheet Based on Check Box Selection

    Hi,

    I am very new to VBA and need to be able to take data from multiple worksheets in a workbook and consolidate it into one worksheet in the same workbook based on check box selections. (sample...
  31. Re: Running VBA Macro based on drop down value in another sheet within workbook

    I'm including it on the View Code option on the specific sheet. How do I put it in a module that is over the entire workbook? If you can steer me to some information on how to do this I think this...
  32. Re: Running VBA Macro based on drop down value in another sheet within workbook

    This didn't work :(
  33. Re: Running VBA Macro based on drop down value in another sheet within workbook

    I'm trying to have one general page, worksheet where a certain question is asked via drop down that has options, Yes or No

    Based on the answer to the question to the general page, I want to then...
  34. Re: Running VBA Macro based on drop down value in another sheet within workbook

    I'm trying to have one general page, worksheet where a certain question is asked via drop down that has options, Yes or No

    Based on the answer to the question to the general page, I want to then...
  35. Re: Running VBA Macro based on drop down value in another sheet within workbook

    This didn't seem to work :(
  36. Re: Running VBA Macro based on drop down value in another sheet within workbook

    Thank you for your speedy replies!

    Can you please tell me how I would go about modifying the below to incorporate the sheet name as both users have mentioned above?

    I apologize I am new to...
  37. Running VBA Macro based on drop down value in another sheet within workbook

    Hi I am able to successfully run the below VBA code (right click on Tab w/n excel worksheet and put this in View Code).

    However, I'm running into issues when I try to run VBA code on the same...
  38. Add a filter to all queries in Access database

    Hi,

    I'm fairly new to Access and have built out a database with 40+ queries.

    I want to add a customer number and date range filter to these 40+ queries.

    Is there a way I can have a window...
  39. Replies
    8
    Views
    787

    Re: Issue with Removing Duplicates in Excel

    Please refer to attached zip file.
  40. Replies
    8
    Views
    787

    Re: Issue with Removing Duplicates in Excel

    I checked that unfortunately that is not the issue.
Results 1 to 40 of 49
Page 1 of 2 1 2



Featured


Click Here to Expand Forum to Full Width