weekly

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?

Hi, I am trying to fill in a formula (depending on the if then statement) down an entire column. My macro works for my first selected cell but does not continue down to the last row. I want the logic to continue down through until the last row. My macro is below. Dim sht As Worksheet Dim...

hello I'm looking for ideas for a weekly timetable to my company. timetable is edited every week, there are 5 workers, each one of them has own line colour, I made a hourly grid where his colour showed his avaliability but in my opinion it becomes chaotic. Next, filled in colours table goes...

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...

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...

I'm trying to figure out what combination of sumproduct to use to get the quantity total from the 'Inventory' sheet to the 'Weekly Report'. I'm hitting a wall since Inventory lists multiple of the same style while the Weekly Report has just one for the total. Any help would be appreciated...

Hi All, I want to learn how to do a VLOOKUP in VBA. But it seems rather confusing when reading different sites online. I wish to put the following formula into Worksheet "Weekly Stats" Cell "D3" - =VLOOKUP('Weekly Stats'!A1,'My Stats'!C4:M56,4,FALSE) 1. Worksheets("Weekly Stats") is where...

Hello all, I have an Excel database that has 52 weekly tabs named "Week 1", "Week 2", etc. The tables are identical and they are currently being summed into 2 26-week tabs for 6 month reports. These two tabs are fixed and locked for protection. Is there a macro to set up a dynamic reporting...

I currently use excel to track available sick and vacation time balances for employees. The basic information has been kept on a summary sheet in the workbook. I then have 52 weekly "reports" (work sheets) that track labor hours by type for individual employees per week. When an employee uses...

I manually complete 4 or 5 sheets (some months include 4 weeks, some months stretch to 5 weeks) of weekly staff schedules but want this data to be transposed automatically to a new sheet which will provide an overview of the weekly sheets on a single sheet. This is a screen capture of one my...

We have a weekly excel file that records all our sales, inventory etc. I would like to be able to pull some of the information from last week’s file when I start this weeks, using ‘C:\Weekly\[week2]inventory’!$A$1 works, but to reset all the different cells defeats the purpose. What I would...

Hello all, I work for a food manufacturing business which still operates a largely paper based reporting system. At present the business is unwilling to invest in dedicated software so I am hoping to utilise excel in an attempt to reduce some process. At the moment, 4 departments hand write a...

Hello, I hope someone can help me. Every week a person is working hours. Sometimes more and sometimes less than the contract hours (on a weekly base). I want to count them if they are higher than the weekly contract hours, but go back to 0 if there is a week lower than contract hours (and...

Hi, I have been wrestling with this for a while trying a number of bits of code I have found online but can't find anything that matches what I want to do or can change enough to make it work for me. I have workbooks of data in a folder and I want to copy a range of data from each one into...

This is kind of complicated, so let me see if I can do it justice with an explanation that doesn't take 10 pages. I am working on a scheduling workbook for another department at our firm. They use it to keep track of what everyone in that department is projected to work on over the course of...

Hello I am new here and I'm not sure if this question has been asked before. My problem is that I am creating a report for sales. The report has daily sales. weekly sales, month to date sales and year to date sales. My data set is by day. How can I have them based on the column that I need in...

I would like to modify solution EMT1075. I want to provide weekly allocation amounts rather than monthly. Appreciate any help Here is link to file <tbody> Allocate Hours Across Workdays...

I have two sets of data. The first set contains information about the highest and lowest values in the second set of data. The first set is weekly data; the second set daily data. I want to use the daily data to find out which value occurred first, the highest or the lowest. To illustrate...

Hi all I've been trying to use the formula for adding up weekly totals and using Mr Excels formula/example on youtube: https://www.youtube.com/watch?v=ZbEmZErWdvY =SUMIFS($B$2:$B$14,$A$2:$A$14,">="&D2,A2:A14,"<"&D3) I cannot for some reason copy the actual formula down any more then two...

Hi, Everyday at work I enter the SUMIFS formula on a worksheet to calculate the total dollar amount from a Pivot-table(1). I use the below formula The Pivot table is on the "Weekly Revenue" sheet and the Totals (formula) is on another sheet called "BacklogReview" <colgroup><col...