Loop through copy and paste cells VBA

Hi All,

I am having some trouble with figuring out a problem and I am hoping someone here knows the answer!

I have the following code, which will input 2 figures from one spreadsheet into another as per my attached example spreadsheet. I want to use the value in column A on the Staff spreadsheet to paste into cell B1 on the Calculator sheet and the corresponding values in A4 and B4 to be copied next to the name in columns B and C on the Staff worksheet. and loop through all the names on the staff sheet filling in all the figures in the columns

I hope this makes sense, thank you in advance!

Please Login or Register  to view this content.

You are absolutely right, my mistake, sorry. I took a break inbetween posting this question. That works absolutely perfectly, I cant thank you enough!