spreadsheet automation

I have a workbook where I the hours I work everyday. There are 13 spreadsheets in this workbook, one for each month, and one where I collect data from the other spreadsheets, like hours worked on a particular day, hours needed that month, my total monthly earnings and so on. The issue I'm...

Hello, we are a small mental health facility that began using a new EHR system which has been somewhat disastrous. The problem we are having is looking at a report. We can export to excel (link) https://1drv.ms/x/s!AoxXnX4Qzvyeem4CbgIivHkLvHA but there is a lot of data and we only need table and...

Thank you for taking the time to read this thread. Please help me keep this thread neat and useful to others by not posting anything that detractgs from the objectives It is about Accounting programs and systems being created in Excel VBA. It covers file management fundamentals; Double entry...

Hello Everyone, I am new to excel and looking for some help in identifying ways to pull "Turn around time"between two dates. But that is not all it needs to fulfil multiple conditions on different column for example Year in Column A ,Month in Column B, Data Validation in Column C We dont have...

Hi To Everyone, I am trying to achieve the following Task.. Assume I have 2 different google spreadsheets. Spreadsheet A having 300 entries & it will update daily basis, having Range of A1:O300. In SpreadSheet B, I have two <gs id="55e0d86b-3755-427b-b8db-ebeda470bba6"...

Hi, I've been banging my head against a wall with this and I'm reaching out to the internet for some wisdom and help. I have a basic spreadsheet that shows a request for the cover of hours which is then either then picked up by Group 1, Group 2 or Group 3. What I need to do is show in the...

Hi there, I've created a workbook that's intended to track construction costs per sqft for various scopes of a home build. Example : <tbody> Description Labour Materials Total Labour per sq.ft. Materials per sq.ft. Total General Requirements 2.00 2.00 0.23 0.23 Site Prep...

Does anyone out there have any idea how to go about setting up an excel spreadsheet that can query a print server to monitor toner levels? I have looked everywhere and cannot seem to come up with any results. -Thanks

Background: I am a new intern at a custom interior design company and I have been hired to streamline and simplify the process that they go through with tracking inventory and the time spent on different jobs so they can calculate their job costs accurately. I have spent days working on this...

I am trying to write a macro that will create a report that can be filled in for an entire year with a tab per week, tab for a summary for the month, and tab for summary of each quarter. The reason for this is that the report is probably going to have elements added later on. So, rather than...

Hello! I'm rather ignorant on the ways of advanced coding and complicated excel macros, so I've been looking around many forum posts and still have not been able to find a working answer to my problem. To describe what I would like to achieve, I'll first tell you with what i'm working with. I...

Hi !!! please help me !!! As starter in web pages design I am searchin how to embed a fully functionaly, protected, not downloable, not copiable, but page visitor user interactive excel file in a web page .... thanks a lot for your valuable help. :confused:

I have looked on this forum and been unable to find it. Essentially I am trying to look in another spreadsheet array, find where the data matches a specified cell in the orginal spreadsheet, and return the data. I accomplished that by using: =INDEX('[Sheet2.xls]Sheet...

So I have a macro that formats a bunch of data. Currently I run it, then press CTRL + Page Down to shift sheets, then run it again, then shift sheets, run it, etc. I want to fix it to make it automatically run through all sheets, then return to the first sheet afterwards. Thank you so much...