Sequential dating in excel cells
There will be a varying number of rows in each of the individual sheets.
I could also specify a range on each worksheet that was similar to the appropriate range on the longest worksheet, and zoom that automatically, but that's not ideal either, because some of the row heights vary from sheet to sheet, and again I'll end up with different font sizes. If he use another 5 days in July the remain balance of 5 days be automatically entered in the tab from Aug to Dec.Likewise if staff A took 2 days sick leave in Jan, and 2 days in Mar how can this sick days be automatically sum up in the months after.I am doing this manually at the moment and it is very time consuming and also very easy to make mistake. So I am at work workin on this report and I need a function that will make Excel automatically insert the today's date in a cell (let's say D90) when I fill the content of another cell (for example C90) and the that will be inserted will never change.Thanks and sorry for this long questions Hello, I need to know how to auto-fill text based on text in another cell. I tried to use the =TODAY( ) function but it keeps updating the date in the cell to the current date if i reopen the worksheet 2 days later.For example: Every time I enter "CHS" in Column B, I want Charleston to auto-fill in Column C. I need the cell to keep in the cell the date of the day when I filled in the content of cell C90 and do not updated it every time i open the document to the actual date.. Hi All, I got the below macro which uses IE and open the URLs.
If this is not then it would be fien to update every time the workbook is opened. I have to free the first two lines in all the tabs except the first one. Code: I'm trying to come up with a solution to calculate the man hours and days worked over multiple sheets. the first seven sheets are the days of the week and the 8th sheet is where I want to calculate the hours.