daily

i have a file that takes a weekly sales number and breaks it down to daily sales figures so stores have a daily sales target to hit. Each day of the week (sun-sat) gets a percentage assigned to it based on sales volume of that day. When a store closes, i have to figure out how to take that days...

Hi guys! I am in need of VBA code that will copy data from one sheet and paste it into another sheet with some slight modifications... I have some data that is in the current format of:(Columns A through N) <tbody> Name Employee ID Weekly Start Date 1 Weekly End Date 1...

Ok I've got (what I consider to be) a challenge problem. I have a workbook with 11 worksheets that are used (there are more but not printed). FYI- I have a I was wondering if someone could write a macro code, or series of codes, that with the ActiveCommand buttons I've put in: "Noon" -...

<tbody> CM REC JV 10511 √ 54127 √ 10512 √ 54128 √ 10513 √ 54129 10514 √ 54130 10515 √ 54131 √ 10516 54132 √ 10517 √ 54133 √ 10518 54134 √ 10519 54135 √ 10520 √ 54136 √ 10521 54137 √ 10522 √ 50233 10523 √ 50234 10524 √...

HI everyone, So every week people add data into an area in sheet "Daily Input" I need a macro to Copy this data and paste it into the "Years Records" tab So this Is what I need, "Daily Input" Range D7:J300 copy Sheet "Years Records" Look along Row 2 and find the date in sheet "Daily...

Hello everyone. I have created an excel workbook where I write down our daily patients. I would like those daily info to be stored in a database, from which I'll be able to draw info next time those patients visit again. <tbody> ID NAME Father's name Phone RN 1 Mike Aaa 1001 12345 2 John...

Hi I have a spreadsheet which works but it is way too slow - what I'm trying to do is to aggregate daily time sheets by person and job, determining the unique combinations of people and jobs then adding the total values for those combinations by week number. I've used concatenate to determine...

Hello all! Sometime last week I suddenly developed a problem that I've never seen before. I was attempting to open a file from a website - which I've done for months with no problem. But that time, I got a box saying: "Excel cannot access 'Daily Reports". The document may be read-only or...

Hi - trying to formulate a Gantt chart to allow me to show where some of our employees will be on a daily basis. So far I have the formula: =IF(AND(G$8="Tues",G$9>=$D17,G$9<=$E17),"X","") This allows me to highlight where people are (in this example) every Tuesday - is there a way to highlight...

I am trying to generate a formula that will use one cell whose contents will change daily, to predict a total amount by the end of the current month. I would like for this to a month to month formula, that is only for the current month. The layout of my sheet is: <tbody> MONTH AMOUNT...

Hi I have a small table that gets updated daily from a shared workbook and I was wondering if there is a way to save his data into another excel document on a daily basis and at a specific time and could this also be done with out opening the documents. Currently I open excel and copy the data...

Hi All - been stuck on this for a day (in between other tasks). We have a weekly leavers/changes/transfers workbook which we add to daily. I need to be able to pull the data from this workbook into another. I need the first 6 columns (A:F) if the date in column f is sometime last week. The...

First of all here is my function; =IF(A7<>"",IF(COUNTIF($A$7:$A$33,A7)>1,"0.00",$D$4),"") This formula pulls adds a fee (cell D4) when you sign in, and SHOULD allow a sign out and not add a duplicate membership fee. This is meant for column B, is it blank when the parallel cell in column A is...

Hello people, Need lil help here. I have this table where a month data is linked to a cell with daily data. As and when daily data is updated month data should get automatically updated along with whatever the data that is accumulated in the month data. For eg July monthly - 250 Daily - data, so...

I have a sheet that people are supposed to update the percentage daily in a horizontal date range daily. My main sheet calculates the current percent complete in cell S6 on sheet "Daily Progress". On that same sheet in C1 is the current date. I'd like to leave this cell a formula equals to...

HI I have an excel document that I populate daily. I run a Crystal report and export that then I copy/paste the columns in the final 'form'. The form changes only on 2 areas daily. Dates of Appointment: July 4, 2018 and Date run: Thu July 5, 2018 @8AM ( i can keep the time static...

Hi, I want an easy way to access daily reports using a calendar as a dashboard. I have already created the calendar in Excel which runs from 2018 and 5 further years to future proof the document. On a separate tab I have created the Hyperlinks for every daily report for the next 5 years so that...

Good Morning, I have been trying to write a VBA code all morning to get this table so that there is only one UPC column and one UPC check digit column for each row of data. I need to have the data in columns A-I for each row of a different UPC. There are some rows that have up to 10 different...

Hello, I have a data set that can be 1500 to 2000 rows at any given month. I am looking for a vba to start at the bottom of the data and count up to insert a blank row between hour 2 & 3 (the first count is 22 then it is 26 thereafter to the top.) then change each inserted blank row to be "*2"...

Hi, I have column A with 2198 items (every item has a unique item number) and column K with letters A or B or C example: column A ....... column K 250310 A 250350 B 250110 B 310140...