VBA Copy and past value over sheets.

Hi all,

I am at an impass.

I have a spreadsheet (attached) that will have a macro that does the following.

Section 1 copies the values in two cells and pastes into two other cells on another sheet.

Section 2 requires the user to save (a copy) to a folder under a specific name.

Section 3 then clears the values in cells to be ready to reuse the input sheet.

I have section 3 sorted (no problem).

Section 2 is almost done as I am getting the user to put it in a directory and to specify the name (although using data within the sheet as the file name then it does not require a user to do it would be better)

Section 1 is the impass: How do I do it?

Please can you help?

Ok guys,

I have found this little bit of code and adapted it.

Please Login or Register  to view this content.

BUT it is pasting in to column A ... how can I make that column O ? ? ?

Hello Lensmeister,

Please try not to use Merged Cells. I had quite a time trying to figure out why my Code wouldn't work.
I have removed the Merged Range with Cell H4, and replaced it with Distribute Accross Selection.

Try the attached Workbook.

Regards

Cheers Winon,

I had no choice in the Merged cells as it is a spreadsheet created by someone else

Thanks it works a dream

Hello Lensmeister,


You are welcome.

Glad I could help.

If you are satisfied with the solution I had given you, then please mark your Thread as Solved.

You may also Click on the Star to the far left, at the bottom of this Post, to Add Reputation.

Regards

No problems.

Now for second thread on the saving the file bit that I need to change ...

Hello Lensmeister,

Thank you for having marked this thread as Solved.

The Code in the attached Workbook, seems to handle the merged cells in this issue.

Regards.