Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
'Smart worksheet'
This is probably quite basic really but it's really got me - i'm stuck.
I want to update by personal budgeting spreadsheet so that i have less updating and fiddling to myself. i try to make it as much like my bank statement as possible, so date, description, credit, debit, balance collomns; However i would like to be able to get the sheet to recognise weeks as present i have week collumns which i workout myself. I get paid weekly so it would be be really helpful if someone new a way to do this and also if a can create a 'pick list' or something so that it can update or 'fill in' the next months details for me, any help/pointers will be greatly appreciated |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
'Smart worksheet'
Don't know if I'm following you.
If you're interested in labeling your columns with calculable weekly dates, you might try using 2 rows for each column header. Format the upper row with the first day of the appropriate week, and the row below with the ending day (date). In the next column, just add 7 to automatically get your next set of dates. For example, in B5 enter: 7/19/2009 And in B6 enter: 7/25/2009 Then, in C5 enter: =B5+7 And in C6 enter =B6+7 Now, select *both* C5 and C6, and drag across as needed to fill in your range of dates. You now have "legal" XL dates in your header. You can now construct your formulas to include say: =D5, <=D6 to have the correct values calculated that fit the referenced time frame. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Lorraine.vdWalt" wrote in message ... This is probably quite basic really but it's really got me - i'm stuck. I want to update by personal budgeting spreadsheet so that i have less updating and fiddling to myself. i try to make it as much like my bank statement as possible, so date, description, credit, debit, balance collomns; However i would like to be able to get the sheet to recognise weeks as present i have week collumns which i workout myself. I get paid weekly so it would be be really helpful if someone new a way to do this and also if a can create a 'pick list' or something so that it can update or 'fill in' the next months details for me, any help/pointers will be greatly appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I'm Trying to Construct a Smart Worksheet | Excel Worksheet Functions | |||
Invest smart | Charts and Charting in Excel | |||
How do I stop smart tags obscuring the cells on my worksheet? | Excel Discussion (Misc queries) | |||
smart tags | Excel Discussion (Misc queries) | |||
Smart use of .Activate; .Select; .Copy with Sheets(1) va Worksheet | Excel Discussion (Misc queries) |