LinkBack URL
About LinkBacks
I have a cell formatted like this:
Monday
3/19/12
can i make it so that when i drag it down to change the day (monday) and the date (19) only? it will only change the year (12)
I have a cell formatted like this:
Monday
3/19/12
can i make it so that when i drag it down to change the day (monday) and the date (19) only? it will only change the year (12)
"I wish I knew half of what you guys have forgotten"
Right click rather than left when you drag fill the date and you will be presented with a menu asking how you wish to fill the cells and one of the options will be by years.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks