Auto Populate Calendar Days Based On Month / Year And Auto Insert Work Based On Dates / Name

Jul 31, 2013

I am trying to auto generate a calendar based on two drop down menus - Month and Year.

Once the month and year is selected I want to import all work orders onto the calendar based first on the "Labor Name" found in the list of work tab, then assign each work order for that labor name to the respective date on the calendar for the month.

August PM Schedule Demo.xlsx

View 2 Replies


Auto Populate Excel Calendar Based On Date Ranges

Dec 4, 2013

I am trying to have the calendar in the second tab of the attached excel file to auto populate based on info in the first tab.

In the first tab, there is the start and end dates of certain projects. The calendar will need to only show the project name of every project being worked on that specific day.

Some days will have more than one project being worked on, the Calendar will just need to list them all under that day. The Start and End dates count as days the project being worked on as well. We will also need the calendar to auto update whenever we modify the dates in the first tab or add/remove projects (rows).

View 5 Replies View Related

Formula To Sum Sales Over 12 Month Period Not Based On Calendar Year

Mar 27, 2014

I am writing a formula that will sum data for a 12 month period that is not based on a calendar year. For example may have data starting in June 2011 running to date, but not every month. If I set a start date for Year 1, say April 2012, I need to see Year 0 numbers (anything prior to April 2012), Year 1 numbers (April 2012 to March 2013), Year 2 numbers (April 2013 to March 2014), and so on. Date format is currently mmm-yy.

If this could be performed via a macro which references the database (spreadsheet), then even better. The database will contain multiple columns, of which two will contain the date and corresponding number respectively.

View 12 Replies View Related

Auto Creating A Calendar Based On A Date In A Cell.

Dec 30, 2009

I am playing around with creating a calendar based on a date (month) I enter into a cell. I am doing this with a simple =date+1.

I have a sample attached. Only problem I am having is that for months with 30 days I don't want the last day to show the first of the next month. But I can't simply remove that as if I entered a month with 31 days I would need it to show the 31st.

View 4 Replies View Related

Auto Text Based On Cycles And Days

Nov 12, 2013

Auto text based on "cycle" and "day"

I need to auto populate cells based on a rule let's say:

Each cycle is 28 days so on day 1, the first cell should say "C1D1", next day "C1D2" and so forth so that on day 28th (cell 28) it should be C1D28.

On day 29, it should say, "C2D1" since it's the beginning of the next cycle on day 1. What formula do I use?

View 4 Replies View Related

Automatic Entry Of Dates Based On Month & Year In Cells

May 30, 2007

I want to create a monthly timesheet which contains 9 columns for
(Date, Day, Project no., Activity, Time In, Time Out, Total Hours, OT Hours, Remarks)

I have used IF Function to calculate Total Hours & OT hours automatically. Time IN & Time OUT, Project No., will be entered manually on daily basis.

Weekday function is used in the Day column to return the corresponding day of the date in the Date column.

Name of the Month and Year will be manually entered in the designated cells I3 and I4 respectively.

Now the solution I am looking for is, the dates should be automatically entered in the Date column (in cells A8 to A38) based on the Month & Year entered in cells I3 & I4. Dates of the corresponding month of the year should only be filled in. (If a month is not having 29, 30 or 31st day, the corresponding cells should be left blank. i.e. nothing should be displayed in the corresponding cells). I am looking for some sort of formula to enter in the cells of Date column (A8 to A38) achieve this. I have searched the forum and could not find anything which could at least give me an idea about the kind of function or formula to be used.

Attached here is the time sheet I am trying to create.

View 8 Replies View Related

Auto-Populate Cells Based On Dropdown?

May 27, 2014

The file is attached here. I would like to be able to autopopulate cells based on a dropdown. The first tab has the final report and the other 2 tabs are the raw files.


View 1 Replies View Related

Insert All Dates For A Month Weekly When User Inputs Month And Year?

Jul 10, 2014

I have created a time sheet in excel (see attached) that will be part of the larger workbook that will be linked with other sheets to auto fill in most fields. I am wondering if there is a way for an user to enter a Month and a Year at the top of the page and that in turn automatically fills in the days of the month by week.

So in attached sheet there are 5 boxes representing 5 weeks in a month. So if we used May 2014 as an example I would like to know if there is a way that once May 2014 is entered in up to top that. Excel fills in the dates in Week #1 with under Thursday showing 1st, under Friday showing 2nd as on for the entire month...

So as the month go by all user has to do is state the month and year and excel fills in the weekly dates for each day in month.

Attached File : Time and Attendance.xlsx‎

View 2 Replies View Related

How To Get Data Entered In Form To Auto Populate Into Calendar

Jun 26, 2014

I am trying to build a Calendar that pulls all of it's entries from data submitted via user form. To be more clear, I built a basic user form in VBA where I can submit this data: name, brief description, Time/duration, and date. Instead of the data I enter into the form populating in specific cells in my Excel workbook, I would like for the information to be populated into a calendar based on the date.

View 1 Replies View Related

Excel 2010 :: Auto-populating Calendar Based On Conditions From Data Table On Another Sheet?

Apr 26, 2014

I'm trying to auto populate a calender style sheet in Excel 2010 based on data from a Work Schedule sheet. The work schedule sheet contains a list of jobs, with each row representing a different job. There is a column for the start date (e.g. 25/04/14) and a column for the end date (e.g. 26/04/14). There are other columns which select resources such as people and vehicles. Each resource may appear on any one of several columns for each row, e.g. Site Operative 1, Site Operative 2 etc.

On the calendar sheet, in which one cell represents one day (e.g. 25/04/14), all the dates are shown along the top going right and all the resources are shown on the left going down.

On the calender sheet, in every cell I want a formula that will look at the Work Schedule sheet and see if that particular resource is being used on that particular date. If it does, the cell can display information from another cell such as the job number or job name to which the resource is assigned; if it doesn't, the resource isn't being used so it can display "Free" or "Available".

View 2 Replies View Related

Auto-populate Sheets Within One Workbook Based On Condition

Dec 20, 2012

I have a single registration sheet that lists names, contact information, and the class someone is in on a single sheet.

(Name, Number, Email, Class 1, Class 2)

I am hoping to automatically populate other sheets in my work book based on classes... essentially making automatically populated rosters. For example, everyone who has Math listed in either Class 1 or Class 2 would have their entire row (with contact information, etc) copied to the "Math" sheet.

View 2 Replies View Related

Auto-Populate Field Based On Dropdown Box Selection?

Jan 20, 2013

I have a dropdown list selection on the form for types of machines. The list of machines, their sizes and related noise level are in a chart on worksheet 2 and I'd like to automate the form so that when the machine is selected, the related noise level auto populates.

The dropdown box has been put in the form using the data validation function.

View 7 Replies View Related

Auto Populate A Third Cell - Based On Data From Two Columns

Mar 24, 2013

I have data in three columns

4.5 9.50 4.657
4.5 11.60 4.789
4.5 12.50 4.654
4.5 13.50 3.930
4.5 15.20 3.826

I need to be able to auto-populate the cell in column G based on values in columns A & B. If I type 4.5 in E2, and 13.50 in F2, G2 should auto-populate with the value from column C

4.5 13.50

View 2 Replies View Related

VBA Code To Auto Populate Fax Template Based Criteria

Aug 14, 2014

I am after a VBA code that I can use to populate a fax template based on criteria's

Basically I have records which are being logged throughout the day via a User form and sometimes there may/maynot be a charge. the user decides at the time. The column is named "to be charged" and is filled with either Yes/ No.

I need to be able to select the date to print or Just the same day date and print all faxes' that have "Yes" for charge This way all the information for each fax is populated and the user can just print.

and if possible mark a Colum non the master sheet as printed with a X or something

View 14 Replies View Related

Auto Populate Fields Based On Model Number In Dropdown?

Mar 14, 2014

I have the catalog #s of some products in column A, and I have the brand in column B, Product name in Column C, and the model # in Column D. I want to create a formula that if I select the catalog # it should autopopulate the brand in column B, product name in column C and the model # in column D!!

And I have the brand/product & model # in a different sheet!!

View 6 Replies View Related

Excel 2007 :: Auto-populate Cells Based On Value In Another Cell?

Nov 29, 2010

I'm creating a configuration tool for instrumentation that has several options. Many of these options are dependent on one another. To summarize, I need to:

*Conditionally lock cells (and populate with "N/A") OR allow selection from drop down list - the list exists, it's the locking and auto-population I'm struggling with

Example: If A1 = No, then B1 = "N/A" and is locked, else allow selection from drop down list in B1

View 3 Replies View Related

Create Calendar In Excel And Auto-populate Content With Specific Fields?

Aug 23, 2013

Looking to create a calendar in excel and auto-populate the content with specific fields I enter. I know how to create an excel gantt chart but I'm really looking for a calendar view instead of a series of columns with dates. I reviewed the original post on Auto-Populating Excel Calendar but was confused by the instructions. (1) create a calendar in excel and (2) show me how to populate the calendar with fields like (dept and project name) into the dates on the calendar? I have two dates that are important (a due date for the project and when that project will be published). Is there a way to have both dates show info otherwise the most important date will be the publish date?

View 1 Replies View Related

Amortization Schedule: Auto Update Based On Loan Period & Number Of Payments Per Year

Apr 30, 2009

I have uploaded a sample amortization schedule.

1. I require the table to adjust itself based on the loan period and number of payments per year entered in D14 and D15 respectively.

2. Also, if a value is entered in column E, then i require the whole table to update as well.

View 7 Replies View Related

Auto Insert Comment Based On Value Entered

Dec 7, 2009

Is there a way to auto insert a cell Comment when a particular value is entered and then have the Comment copied to a cell in another worksheet in the same workbook?

The value entered into the cells i want this function to work with is from a Validation list. If the cell's value was to change, for instance the user going back to a cell to change the value for whatever reason, I would like the previous comments to remain and then give the user the choice to edit comment or not.

I've had a look in the Forums using search but nothing close seems to be forthcoming.

View 14 Replies View Related

Excel 2010 :: How To Auto Populate Data Based On ComboBox Selection

Jan 27, 2012

I have a question on how I could populate data using a combo box selection in Excel 2010.

For example, I have a table with values in Sheet 1, & below that table there is a combo box whereby another table of values can be populated based on the selection of the combo box.

Maybe to make it clearer...

Table 1
Name | Address | Phone number
Andy | Avenue 2 | 999
John | Road 5 | 998

Combo box (selection of names): John

Data derived from combo box - Table 2
Name | Address | Phone number
John | Road 5 | 998

how I could solve this Also, do let me know if this can be done without the use of VBA.

View 4 Replies View Related

Auto-Populate Items From Master Reference Chart Based On Job Description

Dec 3, 2012

I have attached the sheet :

Certain job descriptions require certain training. Drivers needs these two particular trainings and an office employee only needs that training...

I have a reference sheet with what trainings are required for what job. I then want the next chart with each employee name and subsequent job title to have the required trainings automatically checked. (I can take care of the conditional formatting after that).

Job Desc.xlsx

View 5 Replies View Related

Auto Populate Data Values Based On Dependence Of Two Drop-down Lists?

Feb 1, 2013

I am trying to create an easy fill spreadsheet for a game. I am looking to have data values auto fill based off of the entry of 2 prior drop down menus.

I would like to have values for "Move", "Str", "Spd", "Skill", "Armor", and "Value" auto populate after the "Race" and "Role" has been selected. Data for these auto fills I have put on Sheet2 while the main file itself is on Sheet1.

If possible I would like to have Value increase by 5 for every level in "Rank" on the sheet.

View 1 Replies View Related

Macro - Auto Populate The Data, Based On The Previous Cell Values

Aug 3, 2009

the post 5 for the actual issue. This being my first post could not update it correctly. I have put my views int he 5th post which will be more clear.

View 9 Replies View Related

Automatically Populate 12 Month Calendar With Result Depending On Start And Finish Dates

Mar 26, 2014

I've just started working on an FTE calculator and wish to populate a 12 month calendar with FTE depending on the start and finshed dates.

FTE Calculator non nursing.xlsx

I've attached the file. In Column D the user would select the month the staff start and in the Column E the month the staff will finish. I would like the fte that is calculated in Column Z then to populate in the 12 columns AB:AM (Jul to Jun) with corresponding month start and finish.

View 2 Replies View Related

Days Fill Auto According To Given Month?

Aug 5, 2014

I am facing problem in "Month & days" formula

In my current salary sheet "Days fill auto according to given months" from 1-31 as you can see in my attached salary sheet


the Big problem is i want my salary sheet give dates from 23-22 for example if i select "January" sheet should display date from "Jan-Feb" starting from 23rd Jan to 22 Feb only.... and if I select February than sheet should display date from 23rd Feb to 22 March.... and so on

and if there any blank cell left in the dates area it will highlight it with RED auto as u can see in attached sheet.

View 5 Replies View Related

Auto Fill Days Of The Month

Nov 30, 2009

Having a problem trying to figure out how to create a auto list of days of the month.

Currently I have an input cell with the format mmmm/yy

I then have a list using Weekdays($A$1)... +1....+2.... etc etc

While this works for this current month ( novemeber ) as soon as I chnage the input cell to decemember the list messes up.

The list is in the format of ddd dd

View 5 Replies View Related

Auto Insert Rows From Another Column Based On Count

Jun 9, 2014

I would like to insert rows into column A from column D based on the count values and without affecting subsequent values in column B and C. For example. Count of a value in column A =1 and count of that same value in column D=5, THEN 5-1 (count of D - count of A) insert 4 rows in column A (shift cells down) without affecting data in column B AND C. Basically making the counts in column A and D equal.



The above example should look like this -



View 6 Replies View Related

Insert Rows Based On User Input But Then Auto Delete Them At The End

May 25, 2013

I have a spreadsheet that I use throughout the day and have to send an email to another person when a customer makes a payment. The number of products they pay for will be different each time and I have the code to copy the right cells into an email and the code to insert the right number of rows for how many things the customer is paying for however as I use it multiple times through the day, I need the code to insert the right number of rows, copy it over to the email then automatically delete the rows it has just inserted so it is back to basics so I can use it again.

The code I have for the inserting the rows (from searching through forums) is:

Sub PRows()
Dim NextRow As Long
Dim NrOfCopies As Long
Dim i As Long
Const NrOfCopiesDefault = 1
Const NrOfCopiesMaximum = 9


View 1 Replies View Related

Auto Fill Dates: The Sheet To List The Dates In A Column For Each Month Automatically

Jun 17, 2007

I have a sheet with a date and the number of months on it which will change. I need the sheet to list the dates in a column for each month automatically: e.g. Two cells contain date jan07 and the period 10 months. The rows A1 to A10 should have jan07jan16 listed automatically. If I change then change the number of month to 11 I would like the rows A1 to A11 to update automatically.

View 6 Replies View Related

Auto Count And Auto Sum Based On Unique ID

Mar 11, 2014

Possible to auto count and auto sum based on Unique ID.

Download link to the file in question [URL] ..........

So for Example ID 79125 should get a sum 537.39 and count should be 12, also in any given week like 50 , 51 , 52 , week 1 etc.., duplicate entries must be all counted as 1

View 8 Replies View Related

Copyrights 2005-15, All rights reserved