Search:

Type: Posts; User: rezacs; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: VBA: Split out Worksheets to individual Workbooks

    That works perfect, just what I needed.

    Problem solved.

    Thank you very much.
  2. VBA: Split out Worksheets to individual Workbooks

    I have a workbook that has 14 worksheets. I'm looking for some code that will split these worksheets out into individual workbooks while retaining formatting.

    I did find some code that does...
  3. Replies
    2
    Views
    216

    Re: Top 20% of Sales per Agent

    At this point just a table showing the same list but with an indicator in a new column that it is one of the top 20% for that agent.

    By top 20% I want to see which records have the top X sale...
  4. Replies
    2
    Views
    216

    Top 20% of Sales per Agent

    I'm looking to find a way whether it be in excel, power query, power BI or Pivot to display the top 20% of customer sales per agent without the need to create a Top 20% Conditional Format for each...
  5. Re: VBA Split One Worksheet Into Multiple Workbooks and Retain Formatting

    Thanks again. That can work. I think what I might do though is just add a new column to the sheet essentially flagging those users with a value. And then use the original script to filter for that...
  6. Re: VBA Split One Worksheet Into Multiple Workbooks and Retain Formatting

    Looking better, data is copying now into the newly created sheet, but none of the header data or formatting in rows 1-5 are carrying over.

    Are we able to make it create a copy of the sheet1 tab...
  7. Re: VBA Split One Worksheet Into Multiple Workbooks and Retain Formatting

    Almost. The new sheet is created with the name provided. However, the actual sheet remains blank, no data seems to copy.

    A couple things to clarify, the names being filtered are full names...
  8. Re: VBA Split One Worksheet Into Multiple Workbooks and Retain Formatting

    Yes
  9. Re: VBA Split One Worksheet Into Multiple Workbooks and Retain Formatting

    Guess I have one more situation I'm trying to work with.
    Same as previous except I need to select specific items to filter.
    For instance I want to create a new tab as before but i want to filter...
  10. Re: VBA Split One Worksheet Into Multiple Workbooks and Retain Formatting

    Still validating the data but so far that is perfect.

    Didn't dawn on me that maybe I needed less.

    Thanks Fluff, you have helped so much
  11. Re: VBA Split One Worksheet Into Multiple Workbooks and Retain Formatting

    Adding on to this I have a new requirement.
    I still have the same issue as I mentioned originally where i need to keep formatting from the parent sheet to the new sheets and I have multiple rows of...
  12. Re: VBA FreezePanes on multiple worksheets in my workbook

    Thanks, that worked nicely as well. Did need to remove the +1 after PRow in this case, otherwise it was freezing the row under the header row.

    Do you know, would there be a benefit to using...
  13. Re: VBA FreezePanes on multiple worksheets in my workbook

    And of course I just found the answer just minutes after I asked.

    Added
    Application.Goto Reference:=.Range("A1"), Scroll:=True

    on the line before
    Rows(PRow + 1 & ":" & PRow + 1).Select
    ...
  14. VBA FreezePanes on multiple worksheets in my workbook

    I created a vba macro that helps us apply some formatting to our reports before we send them out.

    At this point everything works on a workbook with a single worksheet.

    However, if there are...
  15. Replies
    5
    Views
    418

    Re: VBA Mail a row to each person in a range

    I think i get the direction you were trying to go. However a mail merge wasn't quite what I was looking for, I needed it to create an email with the information from the spreadsheet included.

    I...
  16. Replies
    5
    Views
    418

    Re: VBA Mail a row to each person in a range

    I may have missed something, but it seems to be able to merge into an email I would need to install software(add on) to accomplish this which based on our security rules is not possible without...
  17. Replies
    5
    Views
    418

    VBA Mail a row to each person in a range

    I have some rows of data in a spreadsheet that needs to be sent to different groups depending on the group name or email that is set for it.

    Using come code found on Ron Debruin's site I was...
  18. Re: VBA Split One Worksheet Into Multiple Workbooks and Retain Formatting

    Those changes worked great.
    Thank you for all your help.

    I did a little more digging and did find one more solution to the color themes.

    Set an initial statement to save the current color...
  19. Re: VBA Split One Worksheet Into Multiple Workbooks and Retain Formatting

    That worked, I did have to update the path since apparently we are using 32-bit 2016 version which would be my main worry if someone runs this on a different version. Would it be beneficial to add...
  20. Re: VBA Split One Worksheet Into Multiple Workbooks and Retain Formatting

    Thank you Fluff, that worked great.

    Just 2 questions to see if there is a way to work with a couple aesthetic items:

    1. Is it possible to update the Set Ws line so that it can adjust for...
  21. Re: VBA Split One Worksheet Into Multiple Workbooks and Retain Formatting

    Couldn't see a way to edit my original post.

    Seems the link to the sheet didn't work so here is an updated one:
    https://1drv.ms/x/s!AuRLozE5HIbIiJsIkOTo81JpcWutXw
  22. VBA Split One Worksheet Into Multiple Workbooks and Retain Formatting

    I'm fairly new to VBA. I'm trying to split a worksheet into multiple workbooks based on the value in Column A. I can get the code to work slightly using the some older code I found below but it...
Results 1 to 22 of 22