Find cells contents elsewhere & 2 Buttons to copy a set of cells.

[ARowbot]

Hi!

I have a few 'little' challenges... I have attached a template spreadsheet so that you can see what I am already working with... 2014-2015 Planning template.xlsm

Challenge 1: I would like a button in J1 or J2 that will search for today's date (currently in J1) in column B and select it so that the week that today is in, is visible in the window.


Challenge 2: I would like 2 buttons called "Week A" and "Week B" in K1 and K2 that copy the respective weeks timetable from sheet 2 into sheet 1 at the bottom.


This will make a stressed teachers life so much simpler!

Many thanks in advance and I hope this all makes sense!!

ARowbot

[JOHN H. DAVIS]

Not sure I follow you, but see if this gets you started.

Please Login or Register  to view this content.

[ARowbot]

Thanks for the reply...!

Hopefully I can clear up what I mean...

I'd like a button that I can click so that it automatically scrolls down to today's date (or the week that it is in). Rather than me scrolling down manually.

Secondly 2 separate buttons that will Copy the appropriate week from sheet 2 onto the bottom.

[JOHN H. DAVIS]

Did you test the code too see if does any of what you want?

[ARowbot]

I have tried it...I Can sort of see how it should work but I can't make it work alongside the current macros in there!

[JOHN H. DAVIS]

Does the messagebox depict what you are trying to do as far as finding the value of J1? It is incomplete until I know what you'd like to do after that.

[ARowbot]

I originally got it working to come up with a dialogue box saying Week B. But now it seems to have no impact at all...

EDIT: I now have the macro as controlled by a button and it returns "Week B". However I cannot see how this is related to today's date...

I have included a more accurate template to work with...2014-2015 Planning template.xlsm

[JOHN H. DAVIS]

Try this and see if were getting any closer too what you want. BTW Today() is a horrible name for a Sub. I suggest you revise it. You should never name a sub after a normal xl Function.

[ARowbot]

It seems to be working...However it seems that I haven't fully made it clear..

I'd like these to be separate buttons (3 overall)

1 Button to take me to this weeks timetable.

1 Button to Copy Week A from sheet 2 to sheet 1 at the bottom

1 Button to Copy Week B from sheet 2 to sheet 1 at the bottom.

It seems that you attempted to merge all 3 (Which is beyond what I thought was even possible let alone necessary )

[JOHN H. DAVIS]

Button 1:

Please Login or Register  to view this content.

Button 2:

Please Login or Register  to view this content.

Button 3:

Please Login or Register  to view this content.

[ARowbot]

Really starting to get there! Thanks for your continued help!

Button 1 seems to only return which ever box I have selected however.

Buttons 2 and 3 only seem to work once...

Thanks again John!

EDIT: I now have buttons 2 and 3 working flawlessly by removing the merged cells on sheet 2

[JOHN H. DAVIS]

What do you want Button 1 to do. I'm still not getting it?

[ARowbot]

Basically, It is the same as finding Today's date in column B and scrolling down to it..I just can't get my head around the search function!

[JOHN H. DAVIS]

Perhaps:

Please Login or Register  to view this content.

[ARowbot]

Unfortunately seems to have no affect...

Google has been my friend this time...! For those that are interested...

Please Login or Register  to view this content.