Macro to fill dates as per the selected month in the cell A1
Hi,
I am looking for a macro which should fill the dates if the month is selected in cell A1.
I have two sheets "Input" and "Output". In sheet Input cell A1 I have a list from Jan to Dec. If I select the month in that list then it should fill the dates in sheet "Output" starting from Cell A1.
Please help me.
If it is not possible, please suggest me an alternate....
how to make makro to fill now function in certain cell
stevman,
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Kishore,
Which date should be populated?
Do you have a sample file?
Hello Arlu,
I want the date to start from the starting date to the end date of that selected month. I am attaching the sample file. Please help..
In the output sheet in column A1 it should start the start date of the pirticular month which is selected in the sheet Input. and end the last date in the same column A.
Ex: Jan if selected in Input then it shoud populate Jan 1 to Jan 31 in sheet output from A1: A31.
The same way for other months also.
Last edited by kishoremcp; 09-03-2012 at 05:31 AM.
Any Help!!
Professionals of this website...please help me with an alternate macro if it is not possible or suggest me something else...
no macros (see attachment)
Try this,
Select a month and check output.
Last edited by JapanDave; 09-04-2012 at 03:34 AM.
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks