Macro paste

[nujwaan]

Hi Guys,

I need a macro to get the values from cells D29 and H24 in the Resource Calculator sheet and populate it into cells N8 and O8 in the Input form.

Users will then be able to change the information in the calculator and click the macro again to populate N9 and O9 and so on.

Is there a way to do this?

I've attached the file for you to see.

Thanks.

Nujwaan.

[royUK]

data starts in N14 of he input form

[nujwaan]

Hey Roy,

Sorry that's what i meant.

Just insert some rows to include that title.

Can you help?

[royUK]

Assign this code to the button the calculator sheet

Please Login or Register  to view this content.

[nujwaan]

Hey Roy,

It didn't seem to work.

Just to clarify - what I need is the button to be click and the values from cells D29 and H24 in the Calculator to be pasted in Cells N13 and O13 respectively.

I then need to be able to change the data in the calculator to create new values and then click the button again to populate N14 and O14.

For some reason when I run the code you gave me it gives a dialog box but seems to be getting the value "ERS" and placing it in N13 with no other result.

nujwaan

[royUK]

As I said- the code should be assigned to a button on the calculator sheet

[nujwaan]

I love you Roy.

I really do.

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[nujwaan]

Hi roy,

Just a quick question on top of this.

If I want to make the code so that the button will only populate in columns N and O then how would I do this to prevent people from clicking the button and populating other columns?

[royUK]

Hi roy,

Just a quick question on top of this.

If I want to make the code so that the button will only populate in columns N and O then how would I do this to prevent people from clicking the button and populating other columns?

The code only writes to N & O

[nujwaan]

Hi Roy,

The code only seems to write to N and O if they are the cells that are selected. I was thinking it might be possible to stop people from having cell M14 selected and then clicking the macro button.

If i have M14 selected it pastes the details into N15 and O15.

Thanks.

[royUK]

I don't know what you mean. The code writes only to Columns N & O

Please Login or Register  to view this content.

[garretonufer]

it seems njwaan is saying that even though the macro is pasting into Column N and Column O
the row it pastes into is being based on the active cell.

Ie: if M14 is selected then the macro pastes into N15 and O15 instead of the desired location of: N13 and O13 initially, when a form of loop off set so that when the macro is used repeatedly it will off set the results down the columns of the first sheet.


njwaan i hope i am expressing your concerns accurately.

[royUK]

The code copies the cell values to the next empty row in Columns N & O. I have tested it before posting.

The code is attached to Button 3 on the calculator sheet, captined "Copy information to Input Form"