process

This isn't an "how do I do something" post (yet), but an "is it possible" post. I don't want to invest a lot of time and effort into trying to create something if it isn't possible, so I haven't even started creating a database yet. My background with MS Access is as a user, not a creator, so I...

I'm trying to automate as much as I can with our billing process. The one kink in the chain is getting everything to Quickbooks. Invoices have to be typed in manually which is ridiculous. I transfer them from Excel spreadsheets (link below) and into QB versions (link below). Is there any way...

Hi Experts.. I have one of the html page (website).. I want data from that page in excel.. example- so "process" name should come in A2 then, when i expand to this "process" by clicking on + sign, there are name inside that.. example- so "AOQ" name should come in at cell B3 and so on...

The macro below is causing a memory warning after it is executed a few times. Is there anything I can do to code it better? Application.Calculation = xlCalculationManual Application.ScreenUpdating = False Application.DisplayStatusBar = False Application.EnableEvents = False With...

I have a macro that will process multiple rows of data. It goes line 2, then line 3, then line 4...etc.. The problem is each row takes 21s to process and I have 65,000 rows. I don't mind letting it run but due to other things I'll need to STOP the macro. I've tried the esc button or controlBreak...

Hi all, I have an issue that's been at a dead stop for 2 days now. Prior to my arrival at my job, someone wrote a python script to process some data files. What the script actually does is irrelevant. But the way it was written, the user would start the python exe and then copy>paste the...

So I have a lot of ComboBox on my sheet1, I cant seem to activate it execpt if I go to sheet2, and then back to Sheet1. Then they function as intended. Is it possible to avoid this process, for it to function properly ??? Thanks in advance

I'm trying to take a snapshot of 10,000 different stock quotes using my brokerage's RTD API, *but* they limit me to 500 concurrent requests at any one time. If I exceed that, then I get booted / the API connection gets blocked. So my inelegant-but-probably-simple-solution (that I need help...

I am trying to count the occurrences of a Status column that has the number of "Open", the number of "Closed", and the number of "In Process". I entered the formula to count the number of Open, but it returns #N/A. The format is General and there are a number of Opens but it does not count...

Hi, I have a spreadsheet that for some unknown reason certain users love merging cells. We're in the process of stamping out that practice, but in the meantime as part of an import and VLOOKUP I need to be able to removed the merged calls. The cells are G and H on the sheet and contain...

Hi guys... If i have 200 applications to process daily and i have 12-15 people to process them daily, each application takes about 3 hours. How would I put this piece into an excel formula where I want 3 hours to be average to process each app or ok.. how many people would i need in order to...

Hi! Maybe you can help me. I just started using Microsoft Access, and need a little help. I got several spreadsheets, named po(1).xls, po(2).xls, po(3).xls, a so on , to 150 files. Need to import the data on those sheets to my table on Acces, but instead of repeating the process one at the...

I have a sheet where we calculate usage of an ingredient we use every day based on process orders. Daily Ingredient Usage The SAP GI can change if I fix a process order (didn't issue enough flour for the target) I need a vlookup (maybe an IF) that will lookup the date on above spreadsheet...

Hello team, Currently there is process, where I receive file & copy it to particular sheet in workbook for process. Is there any other way to do so... 1. Select the sheet name while uploading, so that the file copy it to the end row of that sheet.

I have no idea why I am getting an error on this. It was working fine earlier. The error happens on the line that is bold. Sub SHIPJOB(control As IRibbonControl) With Sheets("JOBS IN PROCESS NEW") If .AutoFilterMode Then .AutoFilterMode = False .Range("A1:O1").AutoFilter 15, "x"...

I have Dates running down column D5:D100 In Column F I have Dates and Blanks running down F5:100 In Cell A1 I have a Date and down Column BN I have values which is my sum range. Column D is when they started a Project. F is when they finished. If F is blank that means its still in process...

I have been using a process outlined on the tech republic website (see link below) to highlight the selected row from column A to column L. In general the process works great, however I have found a problem. I don't know if the problem is with the process, or if it is with Excel 365...

Hi all, I am looking for a point in the right direction with regards to speeding up the process of filtering, copying, and pasting some raw data that I have. I have a table with all my raw data (based on observations from a tennis match), and at the moment I want to, for example, copy all the...

Hi all, I have a worksheet that links to an Access query that needs to be refreshed each Friday and someone notified once done. Can this process be automated at all?

Column K has values that may contain a "✓". When a ✓ is present, I would like the row that the ✓ is on to highlight between Column A and J. I'm not sure how to carry out the process all the way down the document, 2000 rows or so. Thanks for any help. K4=✓, So highlight A4:J4 K72=✓ A72:J72