• ## Finding the Median for certain dates from a list of data

See attachedBook1.xlsx

• ## Finding the Median for certain dates from a list of data

I'm having the worst luck haha....when I try uploading the file it gives me error message "The parameter "classname" is missing or invalid".Do you have an email address I can email it to?

• ## Finding the Median for certain dates from a list of data

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

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.

• ## Finding the Median for certain dates from a list of data

I entered this formula but it doesn't seem to be working. I gotta be doing something wrong.

If I sent you the spreadsheet i'm working on could you take a look at it and see what am I doing wrong?

• ## Finding the Median for certain dates from a list of data

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?

• ## Finding the Median for certain dates from a list of data

Hello - I have a worksheet with lots of raw data which includes dates. I need to find the median for each month of the fiscal year from the worksheet of raw data.

For example:

October Median = ?

November Median = ?

December Median = ?

Etc...

Any help will be appreciated.

David

• ## VBA Code to convert data from a PDF to Excel & organize raw data

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.

• ## VBA Code to convert data from a PDF to Excel & organize raw data

Can I copy and paste this code into the macro and it'll work?

• ## VBA Code to convert data from a PDF to Excel & organize raw data

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?

• ## VBA Code to convert data from a PDF to Excel & organize raw data

Thanks, Carim! I'll check this out.

Do you know if there's a way to organize the data in column A (see attachment) into the respective cells in worksheet "SIRs" ? The same cells you included in the macro you helped me with?

• ## VBA Code to convert data from a PDF to Excel & organize raw data

Thanks for your response, Kenneth. I have Acrobat Adobe Pro...if that makes any difference?

• ## VBA Code to convert data from a PDF to Excel & organize raw data

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!

• ## Copy & Paste to the next empty row/column in a new worksheet, multiple times

I'm sorry, Nonno....I'm new to all this and don't understand what you mean about code tag? I read the rules but honestly I don't know what that means.

• ## Copy & Paste to the next empty row/column in a new worksheet, multiple times

Thanks Carim! It worked perfectly!

• ## Copy & Paste to the next empty row/column in a new worksheet, multiple times

Thank you, Carim. Attached is my file. I'm copying from the "Raw" worksheet over to the "SIR" worksheet - which is the one I'm using to organize the data into rows and columns.

• ## Copy & Paste to the next empty row/column in a new worksheet, multiple times

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: