Posts by jlsprink

  • USD 75.00 VBA macro to extract data from excel spreadsheet and create pdf's.

    Re: USD 75.00 VBA macro to extract data from excel spreadsheet and create pdf's.


    No worries. I believe I'm good!! It seems (at least on a couple of test runs) that wherever I had my cursor in the EntirePopulation worksheet, that was the header row that was being used. (just for the pdf with the complete data) When I left the cursor in A1, it tested out perfect. Not sure how or why I moved it in the first place or if it all is just a coincidence, but all is well. :)


    Thanks again for all of your help!


    Jeff

  • USD 75.00 VBA macro to extract data from excel spreadsheet and create pdf's.

    Re: USD 75.00 VBA macro to extract data from excel spreadsheet and create pdf's.


    Hi Wigi,


    Thanks so much!! Also thanks for noticing the page break issue. I noticed that too late. They look to be working great now except for the report that has all of the records. ("Fixed_Income_Aging_....") For that one for some reason, it is repeating like the 12th record on the first page as the header for the rest of the pages. Maybe an anomaly and I'll try again a bit later. I forwarded you an additional payment and in the spirit of the forum, sent OZ 10% of that.


    Thank you again for your amazing work and efforts.


    Jeff

  • USD 75.00 VBA macro to extract data from excel spreadsheet and create pdf's.

    Re: USD 75.00 VBA macro to extract data from excel spreadsheet and create pdf's.


    Hi Wigi,


    I was so eager to check it out that I remotely logged into my work computer to give it a try. Super excited about how it worked and couldn't be more impressed or satisfied with your work. Much props. One thing I was wondering if possible, on reports with more than one page, could the header information that is shown on the first page ("Department", "AGE", "CUSIP", etc.) be shown on each page of the pdfs? No problem if this is too cumbersome or time consuming, just let me know. If it is doable, I'd gladly shoot you over another USD 25.00 for your efforts. Again, if that is unreasonable, no problem at all as I'm very satisfied with the results you were able to come up with.


    Kind regards and much respect!


    Jeff

  • USD 75.00 VBA macro to extract data from excel spreadsheet and create pdf's.

    Hello,


    Paid Ozgrid USD 7.50 Transaction ID9HL90308245058638


    I get a data dump in an excel spreadsheet and I need to separate the data by Department type (Column A) so that a .pdf report can be created for each Department Head. Ideally this would be a click of the button approach where the pdf files are automatically saved out to a directory, the naming convention should be “AGED Department Name Date”, (i.e. AGED Public Finance 110116). The path that I need it to be saved to is G:\Downloads\Aging\AgedPDFFiles. I’m thinking that a tab can be created for each department’s output and then from there a pdf file can be created, but I’m open to suggestions by the experts here. The end game is to get the information into a pdf format for distribution.


    I also need the whole report (all the data) in a pdf file as well. I’ve been calling the complete report, “Fixed_Income_Aging_XXXXXX.pdf” where the XXXXXX is the date. If I can get a page break between each department on the whole report, that would be super. For example, there would not be a page with two different departments listed on it.


    In the attached spreadsheet, the “EntirePopulation” worksheet will be the starting point. I’ve populated Sheet2 and Sheet3 as examples of what I need the output to look like for the pdf report. Sheet 2 represents the “Public Finance” department output, Sheet3 represents the “Government” department output. So in this example, there would need to be 11 different pdfs . 10 created for the different departments and the one complete report. This list could expand to more departments.


    I’ve also attached a pdf version of how I’d like the output to present. Notice the header information. I would like the date (which would always be prior business day). Also the title “INVENTORY REPORT” as well as a page number reference if possible. It wouldn’t be a problem if I had to adjust the header information in the “EntirePopulation” worksheet each day if that is an option that could be utilized.


    One more caveat: The sort is correct on the “EntirePopulation” tab, but before the output is generated for the Taxable Odd Lot output, the sort needs to be changed. For that department the sort should be Inventory # (smallest to largest) , then P-AGE (largest to smallest), then Cusip (smallest to largest).


    Hopefully all this makes sense and the attachments help to illustrate what I am looking for. No time crunch at all on this project.


    I appreciate your time.


    JL

  • USD 20.00 VBA macro to sort two ranges of data in output

    Working on automating a project with many steps and currently need help before I can proceed. Here I am trying to get some VBA code that will sort two different ranges. The ranges may expand from day to day (number of rows in each range will differ), but there is specific detail in each range that I think can be utilized.


    I've attached a worksheet with the raw data in Sheet1, and the desired results in the "Desired Results" tab.


    Specifically here is what I am trying to do:


    The first section I need sorted by largest to smallest (column J). This sort will always begin with the first record in column J (not including header info) and end with the last record that has data in Column E.
    The second section that needs to be sorted will always show in the last rows without any description in Column E or an amount in columns G and I.


    I've sent $2.00 via paypal to ozgrid.


    Transaction ID5WS40649RD225411V


    Thank you very much for your time and I'll more than likely be back again soon. :)


    JL

  • USD 20.00 VBA code to find value in column, paste offsetting value to another column

    Hi All,


    Working on automating a project with many steps and currently need help before I can proceed. Here I am just trying to get some VBA code that will search for a value in one column, and then paste the value of an offsetting cell into the next available row in a different column.


    I've attached a worksheet with the raw data in Sheet1, and the desired results in the "Desired Results" tab.


    Specifically here is what I am trying to do:


    Look for a value of #N/A in column Y.
    If there is that value, take the corresponding value in column W and paste the results in the next available row in column F.
    Next take the correspond value that is in column X, and paste that in column H, next to the corresponding results of the previous paste.


    I've sent $2.00 via paypal to ozgrid.


    Transaction ID96N37531CV589752V


    Thank you very much for your time and I'll more than likely be back soon. :)


    JL

  • USD $20.00 Switch Signs Based on Value of Another Cell in Same Row Via VBA

    Hi Friends,


    Got another one here from a data dump. In the attached, I have a Buy / Sell Column (Column Q) that is populated with either an "S" or a "B". If the value is "S", I need the amounts in the related row in columns Y, Z, and AA to become negative. I'm looking for the VBA code to get this accomplished. The attached has the original Raw Data tab, and a Desired Results Tab.


    Thanks a bunch for taking the time to look at. Let me know of any questions you may have.


    Regards,


    JL