I was wondering can I take a calendar and then put hyperlinks or vba to make a sheet if clicked on.
So If I click on an icon on a date, it will copy a certain template sheet, then link it to that date and that icon.
See an excel calendar, I have a few others to play with aw well.
But this one gets updated on the same the page and not sure how the links/icon would follow the dates. I was hoping for maybe 3-4 different icons on a date.
I am trying to monitor my turnover and taxes but struggling slightly to get things to work. I have attached a spreadsheet that has comments inserted to show what it should be doing, I just can't get that to happen at the moment.
Here's a sample data set. How can i perform a vlookup to populate my forecast columns and have it match BOTH the customer column and the SPFKey columns?
******** ******************** ************************************************************************>Microsoft Excel - Receiving Qtr1 2007.xls___Running: 11.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutL20= ABCDEFGHIJKL1Business*UnitCustomerSPF_KeyFORECASTACTUALS*2"NBPRO"Sold-to*PartySPF_KeyJanFebMarTtlJanFebMarTtlVariance3NBPROAAR*CORP.883***01*1224NBPROAAR*CORP.933***020**20205NBPROAAR*CORP.934***09**996NBPROAAR*CORP.999***02*1337NBPROAEROTHRUST*CORPORATION6600***01**118NBPROAIR*CHINA*IMPORT*&*EXPORT*CO.*LTD918***0*11229NBPROAIR*CHINA*IMPORT*&*EXPORT*CO.*LTD919***0*112210NBPROAIR*CHINA*IMPORT*&*EXPORT*CO.*LTD933***042422210610611NBPROAIR*CHINA*IMPORT*&*EXPORT*CO.*LTD934***042424112512512NBPROAIR*CHINA*IMPORT*&*EXPORT*CO.*LTD1742***0*1*1113NBPROAIR*CHINA*IMPORT*&*EXPORT*CO.*LTD1793***0*0*0014NBPROAIR*CHINA*IMPORT*&*EXPORT*CO.*LTD1795***01**1115NBPROAIR*INDIA933***036408215815816NBPROAIR*INDIA934***046176512812817NBPROAIR*INDIA1742***0**00018NBPROAIR*INDIA6601***0*1*1119NBPROAIR*INDIA6602***0*1*1120NBPROAIR*INDIA6603***0*0*00Sheet2* [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
I am trying to compare items on two spreadsheet. I have an existing spreadsheet that lists items and then I import another spreadsheet from a database to confirm if new items have been added that were not on the original spreadsheet. I am about to go crazy and cannot figure out why I keep getting N/A (I know there are some repeats).
I have tried formatting, adding in isna, making sure there are no spaces, and paste special as text... still doesn't work. There are hypens in the data so I have removed them with substitute.
I have a program where I can update the calibration due date of an item. I have attached a cut down version of my program showing the relevant areas. There is usually password protection on the worksheet so it can only be edited via the form (the vba coding removes the password protection before editing, then re-enables the password protection after editing). The "Update Calibration" button is usually on a "Menu" sheet.
Once the form is opened a serial number is typed in the textbox. The calendar button is then clicked, which brings up another form with the calendar on. The due date is selected on the calendar. When "OK" is clicked, the date label caption is then changed to the selected calendar date. When "Submit" is clicked, the spreadsheet will search for the Serial Number, once found, the label caption (being the date selected) will be entered into the cell to the right of the serial.
If the day selected on the calendar is greater than 12 the date is entered correctly onto the sheet. example: calendar date selected = 15/01/2010. shown on sheet as 15/01/2010. However, if the day selected on the calendar is 12 or less, the date is for some reason entered incorrectly onto the sheet. example: calendar date selected = 08/12/2010. shown on sheet as 12/08/2010???? What is going on here? how come the day and month are swapped around if the day is less than 12????
I want to select a date of choice from a calendar in a field within an Excel spreadsheet.
I do not know how to do userforms and so that is why I wonder if I can add this in just a spreadsheet.
This is how far I have gotten so far: After doing the following, I have a static calendar setting in my spreadsheet like a text box showing the current date.
Developer Insert More Controls Calendar Control 12.0
I have to use data tables to calculate Net Present Value (NPV) by altering specific variables.
My NPV is the result of a series of calculations to ultimately arrive at a cash flow figure and then apply the WACC (average cost of capital)
I understand how to use data tables But for the life of me i cant figure out how im going to tell excel that im changing for example wage costs and not fixed assets when trying to asses the NPV sensitivity
My sheet and calculations are all set up
I've done it manually by altering the figures on the Inputs and Data Sheet.
My NPV calculation is on the Workings and calculations sheet.
The data tables i have done manually are on the Inputs and Data sheet.
Sub Moveit2() Dim Quantity As Range Dim Cell As Range Dim Cell2 Dim Breaks As Range Set Quantity = Range("a2", "a21") Set Breaks = Range("g1", "s1") For Each Cell In Quantity For Each Cell2 In Breaks If Cell2 = Cell Then Intersect(Cell2.EntireColumn, Cell.EntireRow) = Cell.Offset(0, 1) End If Next Cell2 Next Cell
End Sub
I have this macro to move things to the right. Sort of like a vlookup in a way. However, it runs using one range @ a time. For example it will look up the quantity in A2 versus what's in Row 1 and if they match, data from B2 would be moved into correct column. However, I'd like to run for multiple columns at the offset so I can don't have to keep changing data in the macro. Like want to run for these ranges at the same time as running the first range.
So I have this assignments. Its about rental services. I need to create a formula where the price is automatically found from a table depending on what drop down menus are selected. One menu is the rental name and the other is the season i.e. high or low, therefore each rental has two prices.
I know i can use Vlookup if there was one drop down menu but how to do the other. I was think it will interms of if statement but i dont know...
Here is the link to the worksheet: [URL] ...........
I use MS Excel 2007 and I was wondering if it was possible to enter data for certain things once, and have that data copied automatically every time I type the text. For example, if I type Blue Car in a cell and type 4 in the next cell, is there a way I can program Excel to enter that data every time I type Blue Car?
I am using a great pop up calendar without ActiveX made by a guy called Phil Johnson. When you click a specified cell the calendar appears. The only problem is that the calendar doesn't default to today's date when it opens.
I have the original file Calendar source code if anyone needs it.
I see that IF statements can only be nested 7 times. How do I create a cell that checks to see what item was selected in the dropdown box of 20 different choices and choose a particular cell range depending on what is chosen?
I currently have a worksheet that when a user clicks on the cell, a calendar form opens. From here they can select a date, click ok, and the date gets placed in the corresponding cell they clicked on.
Now if the user needs to change that date, i want them to be able to click on the cell again, and when the calendar opens, the date in the cell would be selected on the calendar. I was able to do this in a userform, but im not sure how to edit it to work on the worksheet. I am using the below to populate the calendar.
Code: private sub worksheet_selectionchange(byval target as range) if not intersect(target,range("aa16:aa24")) is nothing then .show calendar When the user clicks the date, the below code places it in the cell.
Code: private sub ok_click() with active cell .value=calendar1.value end with unload me end sub
Now the below code was used when I was using a userform, but im not sure how to edit this to pull the date from the active cell.
Code: privatesub userform_activate() me.calendar1=date if not tb is nothing then if isdate(tb.value)then me.calendar1.value = tb.value end if end sub
I have a spread sheet that requires people to put dates in certain cells. I was wondering if it is possible to have a small calendar pop up when the cell that requires a date is clicked on. The calendar would need to show the current month, and future months for the calendar year. I’ve seen this feature in OneNote 2007, and wasn’t sure if this same feature could be created for excel. I’m not sure if this can be done by a macro or not.
Attached is the file wherein I am trying to make the scheduling gantt for UAE calendar where the weekends are Friday and Saturday. I am not able to format sundays as workdays some how through my conditions.
Is there any simple way to build a calendar in Excel? Ideally, all events will be listed on one sheet by date and the calendar will display the events on their respective dates. Is this possible?
Got this neat Calendar from another thread on this site,but it has problems. Played around with what little skills I have with no luck. When you open the calendar go to Jan, 1992 click on first four days and everything works. When you click on Thu 2 the problem begins.
I'm trying to make it so that when a user clicks on a certain cell, a calendar pops up so they can pick a date. This seems like a pretty common thing to want; I hope Microsoft puts it into the next release.
Anyway, I've read the tutorial found at [url]which tells you how to create a userform, add the calendar control to it, etc.
I've also modified it so that the calendar comes up when the user clicks on a certain cell, and so that the form closes when they choose a date.
I had to use the selection_changed subroutine to tell if someone clicked on the cell, but there are some flaws.
First, moving over to the cell with the keyboard arrows brings up the calendar (undesired result; I only want it to come up with clicking)
Second, if the cell is already selected, clicking it doesn't bring up the calendar since the selection didn't change (also undesired; I would like the form to come up whether the cell was previously selected or not).
Now the above would be entered on each corresponding day throughout the month and I would like to keep a running total at the bottom. I thought I had gotten the formula worked out, but in the slots at the bottom there is a total of 152 but there aren't any numbers entered for it to total so what I did was place a -152 after the above formula which brought it to 0 then started to enter my numbers but they were off by 30 I think it was.
Is there a way to set up a designated cell in a spreadsheet with a drop-down box that will have a calendar, so that when you click on a date in the calendar it puts that date in the cell?
I have the following worksheet ,named "Calendar", to make an annual calendar and I'm wondering if there's a way to use it to make a calendar in worksheet named "NovemberDaily". On the worksheet named "NovemberDaily" I want to put in cells C14, G14, K14, O14, S14, W14, and AA14 "11/1/2007" if the weekday of the week matches the date"11/1/2007". Is this possible or is there an easier way of accomplishing this. I'm needing the date (e.g. 11/1/2007) in the cells mentioned because it ties into another formula that I'm using later in the worksheet.
