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:\
-
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?
-
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?
-
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
-
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.
-
-
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:Code
Display MoreSub Macro2() ' ' Macro2 Macro ' ' Range("M18").Select Application.CutCopyMode = False Selection.Copy Sheets("SIRs").Select Range("A1").Select Selection.End(xlDown).Select Range("A3").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Sheets("Raw").Select Range("N26").Select Selection.Copy Sheets("SIRs").Select Range("B1").Select Selection.End(xlDown).Select Range("B3").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Sheets("Raw").Select Range("K13").Select Application.CutCopyMode = False Selection.Copy Sheets("SIRs").Select Range("C1").Select Selection.End(xlDown).Select Range("C3").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Sheets("Raw").Select Range("K14").Select Application.CutCopyMode = False Selection.Copy Sheets("SIRs").Select Range("D1").Select Selection.End(xlDown).Select Range("D3").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Sheets("Raw").Select Range("G27").Select Application.CutCopyMode = False Selection.Copy Sheets("SIRs").Select Range("H1").Select Selection.End(xlDown).Select Range("H3").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Sheets("Raw").Select Range("M15").Select Application.CutCopyMode = False Selection.Copy Sheets("SIRs").Select Range("J1").Select Selection.End(xlDown).Select Range("J3").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Sheets("Raw").Select Range("K18").Select Application.CutCopyMode = False Selection.Copy Sheets("SIRs").Select Range("L1").Select Selection.End(xlDown).Select Range("L3").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Sheets("Raw").Select Range("K17").Select Application.CutCopyMode = False Selection.Copy Sheets("SIRs").Select Range("M1").Select Selection.End(xlDown).Select Range("M3").Select ActiveSheet.Paste Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False ActiveWindow.ScrollColumn = 3 ActiveWindow.ScrollColumn = 4 Sheets("Raw").Select Range("M16").Select Application.CutCopyMode = False Selection.Copy Sheets("SIRs").Select Range("O1").Select Selection.End(xlDown).Select Range("O3").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False ActiveWindow.ScrollColumn = 3 ActiveWindow.ScrollColumn = 2 ActiveWindow.ScrollColumn = 1 Sheets("Raw").Select ActiveWindow.LargeScroll Down:=-1 Cells.Select Range("E9").Activate Application.CutCopyMode = False Selection.ClearContents Range("A2").Select end sub