Posts by moyad612013

    Yea not sure why it's not working. When I confirm it with Ctrl+Shift+Enter it returns "N/A".

    Attached is the spreadsheet.


    I'm getting the data from worksheet "UAC" - column F has the dates and column P has the "length of care" of which I need the median for each month. In worksheet "LOS Totals" is where I'm inputting the formula for each month, beginning in cell B15 through M15.


    I sure appreciate your help...I am breaking my head over this:\

    Great thanks! So essentially I'm trying to get the Median for each month of the year for different thresholds. For example, column F contains dates and column P contains the "length of stay" which counts the # of days accumulated in care (i.e. 30 days, 45 days, 62 days, etc.) - the number of days vary. So I need to come up with a formula that will give me the Median for <30 days, 30-60 days, 61-90 days, and >90 days for each month of the year.


    I bet that might be a pretty complicated formula huh?

    Wow! I had a feeling this would be a lot more complex than I would have wished :\


    I appreciate all your help, Kenneth. It's evident that you know what you're talking about and very knowledgeable...I wish I could keep up Lol! Essentially, I need the data from the PDF to somehow organize into the worksheet titled "SIRs". The following data would need to be organized from the PDF into its respective rows/columns in SIRs:

    • Name of the Program (next blank row in Column A)
    • Event ID (next blank row in Column B)
    • A No. (next blank row in Column C)
    • First Name(s) (next blank row in Column D)
    • Last Name(s) (next blank row in Column E)
    • Date Reported to Care Provider (next blank row in Column F)
    • Time Reported to Care Provider (next blank row in Column G)
    • Description of Incident (Full description of Incident) (next blank row in Column I)
    • Gender (next blank row in Column L)
    • Child's Country of Birth (next blank row in Column M)
    • Age (next blank row in Column N)
    • LOS (next blank row in Column P)

    To answer your questions from post #10, yes the data will go into SIRs. And it would be 1 PDF file at a time. So once I'm done with one PDF, I would repeat the same process for a new PDF and so on.


    I'm attaching a copy of the PDF with the data that I need highlighted in yellow.

    Files

    Notice how on the attached spreadsheet all of the raw data is in column A under the worksheet "Raw". For example, A2 reflects "First Name: John Daniel Status: ADMITTED" - but I would need "John Daniel" to be placed in next blank cell in column C under the "SIRs" worksheet. Another example, A9 in "Raw" reflects "Africa Current Program: Test Program 1" - but I would need "Africa" placed in the next blank cell in column L under the "SIRs" worksheet since that is the child's home county of origin.


    Since I copied and pasted directly off the PDF, it put all the data in column A.


    Thoughts?

    Hello - I recently received help in creating a macro that takes data from a worksheet with raw data and organizes it into another worksheet in specific rows & columns. I'm wondering if I can take this a step further by perhaps copying directly off the PDF and pasting it into the "Raw" worksheet and then run a macro/VBA code that would organize specific data into specific rows on another worksheet (SIRs) and placing it in the next empty cell?


    I'm attaching a copy of the PDF where I need the raw data from (some data has been redacted/changed for confidentiality).


    And I'm also attaching the spreadsheet of which I'm working off of. I've copied the data off the PDF into column A.


    I would need the following information from the PDF organized into the worksheet titled "SIRs":

    • Name of the Program
    • Event ID
    • First Name(s)
    • Last Name(s)
    • Date Reported to Care Provider
    • Time Reported to Care Provider
    • Description of Incident (Full description of Incident)
    • Gender
    • Child's Country of Birth
    • Age
    • LOS


    Any help would be greatly appreciated! :)

    Hello - I have a worksheet with a lot of raw data scattered in various cells. But I need to organize that raw data into specific columns on another worksheet. I tried creating a macro to copy from the raw worksheet and paste into the organized worksheet, into the next empty row, but when I run the macro it replaces the data previously copied and pasted. How can I copy from the raw worksheet and paste into the organized worksheet, into the next empty row; and be able to do this multiple times?
    Here's a copy of my current code: