Excel 2010 :: Inserting Dropdown Calendar

Jul 6, 2012

Using excel 2010, how do you insert a drop down calendar? Will this be able to display the date and then can I add a nuber to it and the result be a date

View 1 Replies


ADVERTISEMENT

Excel 2010 :: Dropdown Calendar To Work When Click In Any Cell In Specified Column

May 2, 2014

I am currently using a pop up calendar in Excel 2010 that with CTL+SHIFT+B that a calendar pops up, you select your date, and then the calendar closes. What I now need is to write a code or formula or something that when I click in any cell in column F lets say that the calendar opens automatically in that cell and then still close automatically after the date selection is made.

View 3 Replies View Related

Excel 2011 :: Insert Calendar Dropdown For Mac

Dec 5, 2013

How to insert a Calendar Dropdown for Mac Excel 2011? Also, do I have to readjust this (for lack-of-a-better-word) 'add-in' everytime the calendar year changes? This will be used for a payroll template.

View 1 Replies View Related

Excel 2007 :: Date Format For Dropdown Calendar

Apr 16, 2013

I select the date from drop down calendar in excel and linked with one cell. when i use the date in vlookup formula it does not work due to linked cell date format.

View 14 Replies View Related

Excel 2007 :: Dropdown Calendar - Date And Time Picker

Apr 13, 2013

I want a drop down calender to choose date from and found that i can use More Controls> "microsoft Date and Time Picker 6.0 (SP4)" for excel 2007 but it doesn't work with other excel and shows a "x" not recognised in some other machines.

View 1 Replies View Related

Excel 2010 :: Hidden Calendar Object

Jun 22, 2012

I have a vba script with forms that use the calendar object no longer supported in Office 2010, so I found a suitable substitute and replaced every instance of the calendar I could find across all the forms with the new solution. All seemed to work great. But when I closed the application and then reopened it, it threw an error saying there was a missing library.

When I went to the references it showed me that the Calendar object was missing. I have scoured the application for every possible instance and eliminated it, but apparently there is one or more still out there lurking in the weeds somewhere. Is there someway to search for the control that is tripping this error?

View 1 Replies View Related

Excel 2010 :: Inserting Column Without Formatting

Sep 30, 2011

Whenever I insert a column in Excel 2010 it takes the formatting from the Column to the left. I want to insert a Column without formatting. Just a blank column.

View 4 Replies View Related

Excel 2010 :: Inserting Pictures As Formula?

Jan 2, 2013

What will show in column B will change each day as a I am creating a ordering picking list and want to show a pic in column A of the item to pick the item. Is there an easy way of doing this.

I have been messing around with the following

=showpic("C:DesktopItems46004978Thumb.jpg")

And thought I may be able to show this as by doing the following in the desired cells

=IF(ISBLANK(B1),"",INDEX(Sheet1!A:A,MATCH(B1,Sheet1!B:B,0)))

On sheet1 I have all the model numbers next to

=showpic("C:DesktopItems46004978Thumb.jpg")

And the index formula will grab the correct showpic string depending on stock code that is showing in various column B cells but this isn't working.....

View 9 Replies View Related

Excel 2010 :: Summing Order Revenues Over Next Consecutive Calendar Days

May 7, 2012

I am using Excel 2010. I am tracking client orders on a spreadsheet. I would like to offer a 60 percent rebate on revenue from orders placed between the first order date and 30 calendar days thereafter. On day 31 and continuing through day 60, I would like to offer a 40% rebate. On orders placed on day 61 through 90, I would like to offer a rebate of 20%. From all of the orders placed by clients who start ordering on different dates, I need to sum their order revenue in these three time periods. I have the individual client order data arrayed on my spreadsheet - one order per row.

I am capturing the unique client ID number (Column A), the order date (Column B), and the associated revenue (Column C). Keying off of their unique ID number, I would like to calculate the sum of how much revenue is generated in calendar days 1 through 30, days 31 through 60, and days 61 through 90 from the very first order date from any given client. The start date can be any date in the month, so I can not rely on any calculation that uses the calendar month. Orders are not necessarily placed every day. Multiple orders may be placed on any given day, and then no orders may follow for many days afterward.

View 1 Replies View Related

Excel 2010 :: Inserting New Rows In Selected Files?

Mar 3, 2010

I have problems inserting new rows in selected files. The files with the problems have a macro. I don't know if the problem can lie within the macro. There is no error message, it just won't insert the new row(s).

View 4 Replies View Related

Excel 2010 :: Inserting Columns / Rows And Cells

Nov 20, 2013

For some reason I don't seem to be able to insert any columns/rows/cells in to my excel spreadsheet. This is a problem in both basis sheets and more advanced ones.

View 1 Replies View Related

Excel 2010 :: Code For Inserting And Removing Dates

Dec 14, 2012

I need a code that when i place a date in a cell D10 (Example:25-January-2013) it will then add 40 days of dates daily to AP10.In D9 can it also add the weeknumber (every 7 days the weeknumber increases by 1) corresponding to the day date in D10 (iso).Can this be attached to a button.Enter the date in D10 then press the button and the dates auto insert across the sheet daily to AP10.

Can the button say ADD DATE or REMOVE DATES.First date in D10.When the button says REMOVE dates all dates deleted when button pressed and cell D10 then says "add date here".If no date is placed in D10 and ADD DATE button is pressed a warning messagebox appears and says NEED TO ADD DATE .Will not work until date entered.When date entered in D10 "Add Date Here" disappears until REMOVE Date button is selected and again "Add Date Here" is displayed....not sure if this is possible but would be good if achieved. Excel 2010

View 3 Replies View Related

Excel 2010 :: Inserting Blank Row In Table Without Copying Formula

Mar 15, 2013

I am trying to insert a blank row into a table (created using the table function in Excel 2010) without the copying the formulas. Every time I insert a row the the formula is copied.

View 3 Replies View Related

Excel 2010 :: Inserting Sheet Name Into Footer Of Every Worksheet In Workbook

Mar 26, 2013

I am trying to add the sheet name to the center footer for each worksheet in a workbook. The workbook has about 80 sheets and it is cumbersome to do this manually. I am using Excel 2010.

I have tried to record a macro capturing what I do manually, but when I run the macro on another sheet, it does not add the sheet name to the center footer.

I have tried searching for a macro online and the ones I have found just crash excel.

I know I am probably missing something obvious in my macro code.

View 4 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

Excel 2010 :: Calendar - Set Up Specific Time Frame And Due Date To Exclude Weekends And Holidays

Apr 9, 2014

I'm using excel 2010 on a pc. I need to create a calender. So far I have been using the tutorial for the pop up calender. The result I'm looking for is to set up a specific time frame and have the calender provide the "due" date. I would like the due date to exclude weekends and holidays. Would I be able to do this with the pop up calender?

View 3 Replies View Related

Excel 2010 :: Dropdown Box And Formula?

Mar 14, 2012

I am using Excel 2010 .I have set up Data validation for a dropdown box so I can select from a list of items. In the old versions of Excel the actual drop down arrow used to appear in each cell. In the version I have, the drop down arrow only appears when you select the actual cell. When I did the validation I checked the " In-Cell Dropdown", but it still doesnt put the arrow in the cell. Is this functionality available in Excel 2010 ?

My second issue is a formula.

The last name is in a list of items and users have to select Yes or No to theitems on the list. I am wanting to create another spreadsheet that automatically populates based on their responses.

In short, I want to be able to set up a rule or formula that states if the answer in column A is "y" then I need the information in column B to be displayed.

The ultimate aim is to get a automatic sub set, (in another tab), of the orginal information based on users responses.

View 2 Replies View Related

Excel 2010 :: VBA Code For Inserting Text In All Column B-cells Of Multiple Selected Rows

Jul 11, 2012

Software: Excel 2010, Windows 7

What is the VBA code for inserting text in all column B-cells of multiple selected rows?

I am creating a worksheet with a table containing various data related to orders of various materials (this is more or less data gathering from an older, paper-based 'system'). This table spans, columnwise, from A to D and expands downwards as more orders are added. The information in each column is: A=order number, B=type of material and C=material specs. and D=additional comments.

I've set it up so that the only thing I really have to do is to insert the type of material in the cells of column B, and the rest will sort itself out. Instead of having to insert a new row for each new entry and manually typing in the name of the material (these entries are often done in the midst of already existing data), I created several similar, macroed buttons for the different types of materials we use. These macros work by selecting the row of the currently active cell, inserting a new row and then add the name of the material in the column B-cell of this new row. What I am having trouble doing though, is to get the text-entry to work for a selection of multiple cells.

As an example, lets say that I would like to add 5 orders of "Grade A Steel" in the middle of the table - in the row above row 8. With the macro I currently have I can select cell B5, click the macro, and a new row will be inserted with "Grade A Steel" in column B of this new row. This action could be performed 5 times over, but would be easier if I could just mark a range of 5 cells, say B8:B12, click the macro and get the text/data inserted the column B-cells of all 5 of the new rows. So far I've been able to create a macro that inserts multiple new rows, but I've only been successful in filling the column B-cell in the first row leaving the 4 below empty.

View 8 Replies View Related

Excel 2010 :: Conditional Formatting And Dropdown Box?

Jan 5, 2013

I'm running Windows XP with Excel 2010. I would like to be able to have a group of 19 boxes of which each box has a unique entry, ie 1, 3B, 5C etc. Each box I'd like to have a way in which when selected only the single or dual unique characters show as a color. See attached spreadsheet with sample. When a cell with lets say 1 is selected, a drop box appears and the color and description are shown. Select a color but only show the 1 and the color selected, leaving behind the description. How can I do this for all 19 boxes. This seems like its a classic conditional format. Unfortunately it appears to be several orders of difficulty than a normal conditional format.

View 2 Replies View Related

Excel 2010 :: Sorting / Filter Dropdown?

Mar 25, 2014

I'm trying to add a sorting filter dropdown on some columns in a sheet. If I select the column, then use Data -> Filter, it adds the filter. on that column. But then, if I select another column, the "Filter" button in the tool menu is already selected, even though there is no filter for that column. If I click it, the filter on the other column disappears. Then, clicking it again adds a filter for every single column. It seems I'm not able to select f.ex. 3 different columns and add a filter to only those. It's either all or none. Is this how it's supposed to work?

View 2 Replies View Related

Excel 2010 :: Dropdown Box To Hide Columns

Jan 31, 2012

I have seen in a number of spreadsheets that you can create a drop down list using data validation that hides certain columns depending on what you select. this leads me on to my question...

I have created a Gantt chart for an entire year and what to put a drop down box in C1 that contains four selections (Q1, Q2, Q3, Q4) to represent the four quarters of the year. I want to work it so that when the user selects Q1 it hides the columns where the other Quarters of the year are kept so you can only see that quarter.

If that is possible I would then like a second drop down box that allows the user to select a specific week.

Q1 is columns AW:DI.

I'm using excel 2010.

View 1 Replies View Related

Excel 2010 :: Dropdown Box Choice To Populate Next 2 Cells?

Jun 6, 2014

But for the life of me, I can't get it to do what I need it to do. Excel 2010 user, and I've attached my file with the information, and descriptions.

View 5 Replies View Related

Excel 2010 :: Auto Complete With Dropdown List?

May 21, 2012

My Excel 2007 has "auto complete with a drop down list". When I type in the first character, a drop down list appears listing all the entries in that column tha start with that character. I click on one of the entries and the cell is "auto completed" with that entry. Sure is handy. I try to find that functionally in Excell at work, Office Professional 2010, and no bueno for kaki.

View 3 Replies View Related

Excel 2010 :: Dynamic Dropdown List Of Dates?

Aug 9, 2013

I'm trying to create a set of three dynamic/dependent drop down lists of date values, based on a set of imported data. Depending on whether the preferred choice is to list all dates in a range or just dates on the 15th, the available start and end drop down lists will change.

In addition, if possible I would then like to display a list of valid dates (not sure if this needs to be VBA).

The attached sheet shows/explains what I am attempting but here it is as well:

If B3 is set to show all dates in the month then:

the first dropdown option for C3 will be the first date of IMPORT (D2)
the first dropdown option for C4 will be the C3 value, to the last date in IMPORT (D) column

If B3 is set to show 15th of the month then:

the dropdown for C3 will be the first date of IMPORT (D) column with a date of 15th the dropdown for C4 will be in the range of C3 to the last date of IMPORT (D) column with a date of 15th only dates of 15th will be listed in both C3 and C4 dropdownlists

General

the dates in IMPORT column D are taken from IMPORT column A, B & C, which will be imported and will always be date sequential the number of rows of date entries will change with every import but there will never be any blank rows between dates the values in IMPORT columns A, B & C will always be numerical, and can be referenced if required [ideally] the LIST OF DATES will be populated with the date range, based on the option selected in B3

I'm fairly familiar with Excel (2010) and I have also done some VBA but I'm new to dynamic, nested dropdown lists and I'm unsure what the most practical way is to achieve this.

View 1 Replies View Related

Excel 2010 :: Populating Field From Dropdown List

Oct 24, 2011

I am using windows 7, excel 2010 I have a work book, my price list is sheet one and my list of customers and what discounts they get per item in sheet 2.

I choose customer on sheet 1, say i choose a & L sales, well on sheet 2 it shows they get a discount of 45 percent. so I want the 45 percent to show in cell 4r on sheet one, but if the dropdown box shows customer a & V it should show 35 percent because that is what it is on sheet two in cell 3c.

sheet two has 158 customers and each get a difference discount for that product

View 3 Replies View Related

Excel 2010 :: Hiding Rows Based On Dropdown

Mar 6, 2013

I am currently working on a workbook for work. It is a basic input output sheet. I have data from work that i copy and paste into sheet 1 and I have it arranged into sheet 2.

I am using windows 7 with Excel 2010, though needs to be compatible with 2007 using XP.

What I am trying to implement. I would have a drop down box in cell AD-4 with the current list

Select
Week 1
Week 2
Week 3
Week 4

What I want to implement is a code that if I select "week 1" from drop down then it will hide the entire row if data in column B = week 2, week 3, week 4, week 6

also

If week 2 is selected then hide entire row if column b = week 3 , week 4, week 5

so basically hide the weeks that are after the current selected week.

In addition to this I would also like to hide the entire row, regardless of drop down selection if data from J, K and O all = 0 or (blank).

(the first row is the current Row labels, I have a lot of current hidden columns).

A
B
J
K
O

Supervisor Name
Agent Name
Needs Complete
Completed w/o Turn in
Needs Turn In

[Code] ........

View 7 Replies View Related

Excel 2010 :: Add Search Box At The Top Like Traditional Dropdown AutoFilter?

Sep 4, 2013

I really like the slicers in Excel when working with data scenarios, but I don't like having to scroll up and down through the list of options.

Is there a way to add a "Search" box at the top like the traditional drop-down auto-filter? Or, does any loophole to making one?

View 2 Replies View Related

Excel 2010 :: Getting Error When Try To Add Dependent Dropdown List

Oct 29, 2013

Creating a spreadsheet in Excel 2010 and am creating the dropdowns from a separate sheet in the workbook. There are no spaces and I don't know why I keep getting the "The Source currently evaluates to an error."

I am entering the Data Validation to reference the first cell I need "=INDIRECT(H3)"

I have put the spreadsheet on dropbox. When you select the "Sequencing Platform" drop down, it need to give just the dropdown for the platform selected.

[Code] ..........

View 2 Replies View Related

Inserting Calendar Into A Sheet

May 25, 2007

I've got the calendar to work by right clicking in a cell and selecting insert date, however I'd like the calendar to pop up when a cell is clicked on.

View 12 Replies View Related

Excel 2010 :: Not Show Blanks In Dropdown List With AutoFilter?

Jul 21, 2014

How can I get the dropdown list to not include blank cells in the list reguardless if the sort filter is used or not.

Sheet 1 (STATS) is the dropdownlist Cell B12
Sheet 2 (Orders) is the data, I cant convert to tables because the cells are active and storted Column B2: is the data named.

so I have to use a formula to do this.

Using Excel 2010

See attached sample
Sample.xlsm

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved