Date entry problem

[Headworth]

Help with code to run in excel 2007

Please Login or Register  to view this content.

[pike]

hI Headworth
along long stabe in the dark

Please Login or Register  to view this content.

A bit more of an explination will help

[Headworth]

Hi Pike
I have a database that has 12 columns in column B are dates each time i run the block of code it will populate 9 columns’ I would like to populate 10 columns the 10 one being the dates. This code populates 15 rows each time I run it .So as you can see it will put the first 2 dates in but I cannot get it to continue to put the next date if you run this it puts 01/04/2010 and then it puts 02/04/2010 but then it goes on putting 02/04/2010 each time .I need it to put 03, then 04, and on to end of sheet

Regards Headworth

[snb]

Please Login or Register  to view this content.

[Headworth]

Hi snb
your code works fine but it goes across the columns i need it go down column B and for the date to stay the same for 15 rows at a time and then change to next date for 15 rows etc

Regards Headworth

[pike]

Hi Headworth,
A workbook would help

[Headworth]

Hi Pike
I have add Workbook Attachment
Thank you for your help

Regards
Headworth

[pike]

hm.. maybe

Please Login or Register  to view this content.

[snb]

Please Login or Register  to view this content.

[Headworth]

Hi Pike

I tried your code no luck

In my first post the code will work fine if i use column A
can you see why this will not work in column B
or do you know away with a macro to sort and filter using column B if i move Code ID to column B

Regards
Headworth

[pike]

Hi Headworth,
what are we doing again as im a little lost?

[snb]

@headworth

Did you overlook this post ?

[pike]

maybe

Please Login or Register  to view this content.

[Headworth]

Hi snb
sorry no i did not over look your post
when I add this to my code I cannot get it to work

Regards
Headworth

[Headworth]

maybe
but what year is this your code for it starts at the year date 25/11/4770

thank you for all your help
I am going back to my first post and will change column A and B around
and try and find a way to sort and filter the data using column B with Code ID their must be a way?

Regards
Headworth

[snb]

Please open the attachment and click the button.

[royUK]

I think this thread deserves an award for the most confusing explanation & OP's code that I have ever seen!

[Headworth]

Hi snb
Thank you for not giving up on me your code is great!!
I think for me I will use 2 buttons one with your code and if I can I will add days to your code

Best Regards
Headworth

[royUK]

Try this

Please Login or Register  to view this content.

[royUK]

This is more dynamic allowing the user toinput the first date

Please Login or Register  to view this content.

[Headworth]

Hi RoyUk
Thank you for your code
Please could I ask you to change the code to put 01/04/2010 in 15 rows and code stop
then when I run the code again it would put 02/04/2010 for 15 rows adding 1 date each time Monday to Friday
for Saturday and Sunnday it would 9 rows

Regards Headworth

[royUK]

I don't understand,seems like you wanted blocks of 15 dates before

[Headworth]

Yes blocks 15 that change each day the database is updated on the attachment I uploaded it shows
each day monday to friday the records are changed so your code is fine for 3 days but if I run it again it will put the same dates in again I am sorry for the misunderstanding
What I can not understand is the first post I made the code worked in column A but will not work in B

Regards Headworth