Weekday Formula: When I Change The Month, It Automatically Will Change My Formula

May 9, 2006

=CHOOSE(WEEKDAY("1 Jan " &$C$1),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")

where C1 = the year 2006. B1 has the month Jan and I want to input that into my formula, so when I change the month, it automatically will change my formula. I tried =CHOOSE(WEEKDAY("1 $B$1 " &$C$1),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")

I have 2 columns in a a sheet, some cells in the second (not all cells) contains the current month's number (it comes after the multiplication sign in those formulas).

i need a macro that allows me automatically to advance the month's number each month in this formula (just the month's number), if it's 1 advance to 2, 2 to 3, 12 to 1 etc.... see a example of my formulas below, the formulas are in colomn B, the month number is whatever comes after * (multiplication sign).

Is there a way to make the attached worksheet automatically shade out all the Saturdays & Sundays in any given month everytime you change the Month/Year cell at the top of the worksheet, as example? I've tried using the weekday/Weekend formula, but can't quite get it right.

I know there's a pretty compley formula out there that counts the occurence of say Fridays in 2009 - does anyone have this? I had it before in a file but ranged valued the results showing the count of each day of the week for each month in a given year.

How to use VBA codes to automatically change parts of the formula? Example1: Change formula "=SUM(A$10:A$100)" into "=SUM(A$10:A$1000)"; Example2: Chage formula.........

What i want to do is to change "D" to "E". Next time i run it, it will change from "E" to "G".

I want a macro to do it, so that I don't have to change it manually one by one. For some reason, when i try to use .formulaR1C1, the reference change, and I couldn't get it to work.

I want to automate the following steps when cell A8:A11 changes in sheet "InfoAA":

(1) clear contents and formats of cells A1:A4 in sheet "InfoBB" (2) copy cells A8:A11 of sheet "InfoAA" (which are formulas) and past it as text in cells A1:A4 of sheet "InfoBB". (3) then automatically run a recorded macro named "BoldFirstName"

Basically the situation I have is Sheet2 has many references to cells in Sheet1. Sheet2 is for all intents and purposes a kind of nicely formatted report form, and Sheet1 is the input form.

My ultimate goal is to automatically resize row heights on Sheet2 when cell contents change on Sheet2.

Using a worksheet_change event isn't working I presume because it doesn't see the formula output change as a worksheet change, the worksheet_change is firing only when the input is changed in Sheet1.

how can I capture these formula output changes on Sheet2 (triggered from input on Sheet1) OR is there a way of making a particular sheets rows always adjust in height to best fit?

I'm coding a userform where there are some comboxes which are popolated by values coming from Sheet2. Up to now I work it out (maybe its not elegant but it works).

Now I would like that when the user selects one combobox the values of the other comboboxes are set accordingly to the grid in Sheet2.

I would like to create a financial modeling spreadsheet. Basically my problem is this; I want to have a month by month row for 5 years. For the value of each one I would like it to increase by 950 per month automatically.

I am making several thousand wire tags for a water treatment plant which need to be installed at each end of the cable runs. What I have made so far is tags for one end of the run not the other. I am looking to create a formula to change the tag on the other end so that instead of it saying 1234 to 5678 it would now say 5678 to1234

I have a cell value. For example. A1= 1-2010. Is there a formula that will make A2,A3,A4 become 2-2010,3-2010,4-2010. If A1 changes to 2-2012, A2,A3, and A4 will be supposed to change to 3-2012,4-2012,5-2012.

AS per the attchement, I add a date in the cell H2 and when I select in the cell I2 the date in the column K changes as per the =IF formula..

My question is the following: Would it be possible, once I select the option in I2 to have the formulas in the column K changed for value? I put a example recording a macro!

When trading starts, the TIME value records the time of the last trade, thus the first time will represent the time of the first trade - I am trying to capture this time value. The problem is that if another trade occurs, the TIME value updates to the time of that last trade. The TIME value is fed by a DDE link from a data source.

Is there a way to capture the "first" change in the TIME value ?

Is there a way to use this formula, but instead of looking in Column B, and having to list 00.00.01, 00.01.01, that it only looks at the last two digits of the ##.##.##.

Here is the issue. Each month, the numbers that make up what I need to add together will change. However, all I am really doing, is combining any accounts that have the same sub account (Column B) ending in the same digits of either 00, 01, 02, or 08. So I could have 01.01.01, 01.00.01, 01.02.01, etc. and I am just focusing on the .01 on the end. I would like to say, look at all the sub accounts in B, and only add (G:G) on those that the last two digits equal .01.

I need to know that can we change some value is our formula, For example i was using some bunch of formulas in sheet and then i move that sheet to a new workbook,then i remembers formula as per last workbook. for example.

=VLOOKUP($A1,'[Smithdata.xls]01'!B6:E20,3,0) i need to change file name in all my formula into B/M shape.

=VLOOKUP($A1,'[Smithnew.xls]01'!B6:E20,3,0)

is it possible through some easy way? e.g as we use find and replace for value then what can we do same thing for formula or something else.

I'm working through a huge file and trying to compact it down and make it more workable. I've already managed to get it down to what i need but i now need to add a few things so others can work it more easily also.

One of the ideas i had was the following, but for the life of me i dont know where to start.

The spreadsheet will be updated on a daily basis and at the end of each week we will need to submit any changes we've made to the marketing team. However the change tracker thats built into excel isn't really what i want.

What i though was i should set up an IF formula that would return a True value if any data in that row was changed. Then i could set up a macro to copy those rows only to a new sheet to be sent to the marketing team, this way the structure of the spreadsheet would be kept to make it easier for them.

I want to change the date on my spreadsheet which runs from May 07 to Apr 08 by just inserting one cell, how do I complete this action. The months are in seperate cells.