daily

Hello, Currently have a workbook with three sheets Daily, Weekly, Hours. Is there anyway I can have sheets/tabs where it is named WC 04/06/18, wc 11/06/18 etc, and when you click on them, you have your Daily, Weekly, Hours sheet?

Good Morning, I'm currently working on a scheduling tool for work. I have a "Master" sheet that has everybody's name and work schedules for every day of the week. I then have sheets for every day of the schedule period that contains a position assignment and a daily log that get's faxed to our...

Hi all, I have been searching all night for a solution to the below problem... any help would be appreciated. I have a daily changing worksheet where I required the certain data to be copied and pasted to another worksheet for an annual summary of the all the daily data. The daily...

I have a worksheet that I'm tracking labor hours with. I have 1 tab that all the hours are inputted into, then it filters to a few different tabs. There is a budget, and one of the tabs has a burndown of money available and how quickly we will go through it. For my formula, I'm basically...

Hi, Not got much knowledge of VBA, so thought i'd ask. I have 2 workbooks, 1 has a report from my inbound dialler that shows numbers called and the disposition from one of our agents (sale, call back etc.), the other workbook is a download from Google Adwords that shows the calls made and...

Hello and thank you for any attention my post may receive. My goal is to: find every occurrence of the word "Weekly" in column C e.g. C3,C6; insert 6 lines below (in range A2:C500) each occurrence; fill each occurrence of those 6 blank lines with the data from range A2:C500 where the word...

Hey everyone, I've been scrolling around throughout the forums trying to find a piece of code that will help me with my situation, but have been unable to get any suggestions to work with my workbook. That may be due to it not working with my workbook, or because I can't figure out how to...

Help needed with duplicating formatting (not conditional) At the moment a daily worksheet is completed which has some basic font colour formatting in it, but there is no conditional formatting I can use. It is manually formatted. I want to duplicate the daily sheets to a different layout on a...

Hi you all! I need some help to Copy and paste multiple TABS at a time. We own a cafe and i export reports and then do my own thing. I have to do a daily report so i need 365 tabs and i only know how to copy and paste one at a time and two and then 3 as so on do at a time. Can a Macro do...

Hi Everyone, I have searched the forums for an answer to this but to no avail. I am hoping someone may be able to help me, I have a large data of Sales amounts sorted on a daily dates....these dates look like: 12/11/2017 then 30/4/2015 etc ... I want to group the sales by month then by...

Hello all! Almost all Gantt charts I see online are for kind of long term projects, as every column is a date. Is it possible to have an hourly Gantt chart for a working day (for instance, from 9 AM until 10 PM)? And also, can I have multiple tasks in one row? Let's say there's four team...

Dear All I have a break time calculation excel marco enabled. with this file, i will get the total break time of my staff in a day and weekly total working hours and break timings. i try to get the daily working hour and break time on daily basis but it not worked. the daily working hours...

Good afternoon all, Again, thanks to all the contributors on this site that make my day job easier! I however have another question which I am sure will be extremely easy for someone else. I have two worksheets; Stats sheet and cumulative views. The stats sheet contains details of...

Hello. I have some VB code that saves a file in read only. What I want to do is save over it daily. I am using Office 2016 and would like to know how to "resave" over the 'read only' file daily. Here is the subroutine I am using: Sub ReadOnlyFile() On Error Resume Next 'Keeps going if there...

Hello, I would like to have a macro that will insert one blank column (C) Into a (SHEET 1) workseet. Also if this is do able have the following lookup run at the same time. =VLOOKUP(B:B,Sheet2!H:I,2,False) I work on These type of sheets on daily basis and i cant type to figure how to make...

I am trying to create a spreadsheet that keeps a running tally of totals for the day. What would be a good formula for that?

Hi, In Column A2 to A31 I have date for April 2018 In Column B2 to B31 I am entering Daily Production Data Monthly production target is 720,000 (i.e. 24,000 per day in case of April 2018). If the production on 1st April is say 10,000 (Instead of 24,000) then the required production on daily...

I'm needing to consolidate 6 daily worksheets into 1 worksheet. I also need the summary worksheet to be dynamic and update as the daily worksheets are populated. Any suggestions would be great! I've been able to consolidate the worksheets, however the summary worksheets is not updating as data...

Hi all, I'm just wondering if anyone could help with a macro code I could use on a spreadsheet I have been working on. I have managed to compile just about everything I need to the spreadsheet except for this issue. I download data of orders on a daily basis and paste into each daily tab which...

I have a very large spreadsheet with multiple sheets (all named differently). I have a master list (Master) and a new sheet each day (saved as the date - 3.5.18). I am needing a formula to input into the daily sheet that will tell me if the number listed in column A is also listed on the...