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.
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...
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...
I get the following error when I run that:
Between operator without And in query expression 'QryDatehours.Datehours Between [everything tester].[Arrive_Time]'.
Any thoughts?
Ok, so I played around with the SQL but I get a Data type mismatch error with this. Any thoughts? Would greatly appreciate it!
Thanks,
Eric
SELECT QryDatehours.*
FROM [everything tester] LEFT JOIN QryDatehours ON [everything tester].Arrive_Time = QryDatehours.Datehours
WHERE...
Thanks. I'm a bit of a rookie, so after I created the digits table, and the first query, which shows each date from my start date, and every hour, on the hour.
I'm not quite sure how to create the second query, however. I can select the field from the first query, but what fields am I joining...
Hello:
I am trying to set up a query to look at counting number of customers in a department at any time (census). I have:
[Arrive_Time], which is the time the customer arrives in mm/dd/yy hh:mm format
[Archive_Time], which is the time the customer leaves in mm/dd/yy hh:mm format
What I...
Thanks - this is good to know that it can be done.
One other question on this - the requester has asked to somehow "sync" relevant details related to cases. In other words, for the various meetings and notes in the meeting box within Outlook, if there is a specific reference to "ABC Case", it...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.