Recent content by EBox

What additional information is needed?

I haven't tried any code because I'm very new to VBA and this is way beyond my abilities. The row labels are: "Net Revenue" "Total expenses" "EBITDA %" "Visits" "RVU" Note that sometimes these row labels will be in different rows (e.g. "Net Revenue" may be on row 200 in one file but on row 252...

Hello: I have about 50 files in a certain folder where I would like to pull 4 values from each spreadsheet and assemble in a new "master" spreadsheet. Unfortunately, each file is not entirely the same layout structure, so I cannot simply pull all values from the files that are in discrete...

Hello: I am trying to find a way to write an Oracle query (11g) that finds repeat customers transaction purchases that occur within 72 hours of each other. Specifically, if a customer does a transaction on Day 1, and then again on Day 2, I would like to have a query that will pull the...

Sorry, I meant "Column". Each of the IDs above would be represented in the Legend, with each of the columns above shown on the x-axis. The y-axis would show the % value for each ID/Column above.

ID Level 1 Level 2 Level 3 Level 4 Level 5 Crit Care Obs Codes Total Mcare 4 Total Mcare 5 13 0.012484395 0.043695381 0.446941323 0.310861423 0.1360799 0.008739076 0.041198502 0.289855072 0.362318841 19 0.024390244 0.024390244 0.585365854 0.195121951 0.170731707 0 0 0.4 0.4 60 0.019230769 0...

I posted the data file in my initial post (see link). THe y-axis is a percent and is populated in the Excel file. Perhaps that was done by default?

Ok, I did this - see code below. But not sure how I would condition for the future revised source worksheet that may have less or more rows (I don't want to exclude records if there are more records added in the future, and don't want to have blanks in the graph if there are less records...)...

Hi: I am a real amateur when it comes to Excel macros and I need to find a way to create a bar graph from a simple table in Excel (I have attached a link to the file - data source is on "new data (2)" tab and desired graph is on the "Chart1" tab. Can anyone help with writing a macro that will...

Hello: I often want to assign Tasks in Outlook to other people, which I do. However, when I assign the task, the Category I have assigned seems to get deleted (because I suppose I am not the "owner" anymore, but I would still like it to remain in a category I assigned it to). Is there a way...

Thanks for the guidance - I put in your changes and now get a Run-time error '3021': No current record. I should mention that the [DOS] field I have is in mm/dd/yy format, and I even tried changing your query recommendation above to match that, but received the same error. This [DOS] field...

Hello: I have spent numerous hours evaluating VBA code I found on the internet to calculate Median in a query. The only problem is that I would like to get median values for each date presented in the query result, and the VBA code I am using (the only one that worked) calculates the same...

What would the code consist of? I am not really a coder, so any help you could offer would be appreciated. Thank you, EBox

I would love for it to happen automatically, if that's possible, instead of having to push a button on a form. I do have the import specs loaded up into Access currently, but do not have any append queries. I have been manually just taking all the fields from the imported table and creating...

Hello: I have an Access DB which I import a daily text data file into and then run an append query in order to aggregate it to a cumulative table. I was wondering if there is a way to set up a macro or VB to automate this for me. The daily file name format is ED_Archiveyyyymmdd.txt (example...