Ammendment to working code

[paulary30]

Hello forum users,

I am currently using the following code which works perfectly:

Please Login or Register  to view this content.

The code finds cells with Today's date from a column T in one spreadsheet
copies those cells and 48 cells next to them i.e columns T to BP where Today's date is in T
And pastes those onto another spreadsheet called "Paste".

I need to amend the code slightly so that it finds the cells with Today's date in T but copies from column V to BP or in other words (BP is 45 cells to the right of V) and pastes that in the sheet "Paste"

I no longer need to paste the cells from column T or U where Today's date is in T.

I hope this makes sense. Can anyone help!

[Andrew-R]

Sounds easy enough...

Please Login or Register  to view this content.

[paulary30]

Hello Andrew,

Thanks for replying

I gave the wrong code to begin with. I should have put

Please Login or Register  to view this content.

However I put

Please Login or Register  to view this content.

from the code you gave me to replace

Please Login or Register  to view this content.

on my code and it worked so thanks very much.

[paulary30]

Where do I go to mark this thread as solved?

[Andrew-R]

Happy to help and glad you're sorted.

To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save

[paulary30]

Done, thanks

I have another question - do I have to start a new thread?

[Andrew-R]

If the question is related to the same problem then you can post it in this one.

However, fewer people are likely to click on a thread marked 'Solved' which already has a number of replies, so you'll probably attract more views if you start a new thread.

[paulary30]

OK - it is a different question so i'll post it to another thread

Thanks for your help