Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
columns
Working on a spreadsheet I call "Weekly Activity Report" for employees. It
has columns as follows: date-code-hours-notes If I enter a date x/x/xx, how can I set this column up to fill in the rest of the dates in for me if I have them labeled m-sun in the first column or is this even possible? m x/x/xx l sun x/x/xx |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
columns
If your start date is in B2 say then click on C2 and put this formula in B2 +1 That should work VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=563072 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
columns
Or you can fill in the first date cell. Exit the cell. now click the lower
rihgt corner of that cell. While holding down on your mouse left button, drag down for the number of days you want to fill in. Each row will increase by one day. "tedkilroy" wrote: Working on a spreadsheet I call "Weekly Activity Report" for employees. It has columns as follows: date-code-hours-notes If I enter a date x/x/xx, how can I set this column up to fill in the rest of the dates in for me if I have them labeled m-sun in the first column or is this even possible? m x/x/xx l sun x/x/xx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort the data in 8 columns by two of the columns? | Excel Worksheet Functions | |||
How to swap rows and columns? | Excel Discussion (Misc queries) | |||
Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) |