Moving a selection of cells when a ref. to that selection is placed in another cell.

[Ellogg]

Hi All

This is my first question I have been using some info. I have got from other peoples solutions but have not got the correct outcome for what I require. Would be greatful if someone could point me in the right direction as I am very new to excel/vba/macro programming but its starting to get me keen to try other stuff with excel.

I have attached a jpg showing the excel sheet which has all the data on it. What I am looking to do is when a number is inserted into the cells (B27:B33) blue circle (1) I want the cells next to the same number above to be copied into the cells next to the number put in. The example is number 14 and the cells (C19:Y19) have been copied into (C27:Y27). The sheet is going to be used to work out and calculate the hours worked and hours paid etc. I have filled the days in manually to give a better idea of whats required, I am also going to lock the sheet so only the number boxes are active.

I hope someone can help and am hoping this will give me a better idea of how to use programming to get better results from excel.

Thanks all in advance.

Ian E

Shift Hour Calculation.jpg

[stnkynts]

Untested:

Please Login or Register  to view this content.

[Richard Buttrey]

Hi and welcome to the forum,

Can I suggest you upload the workbook. Pictures are rarely much use for the reasons explained in the rules guidelines area, and most of us are not prepared to recreate your workbook when you have it readily available.

[Ellogg]

Hi Richard sorry about that I will post it soon as in work at minute so not at the computer to put it on cheers mate Ian E

Sent from my HTC One using Tapatalk

[Ellogg]

Stnkynts I will check it out in a bit as replied to Richard am away from computer cheers mate

Sent from my HTC One using Tapatalk

[Ellogg]

IE test.xlsx

Here is the excel sheet

Cheers

Ian E

[stnkynts]

Prime example of why it is easier for us to have a copy of the workbook. My previous code had errors that I couldn't easily test. Sorry about that, try this:

Please Login or Register  to view this content.

[Ellogg]

Stnkynts

Sorry for delay in reply been off work so only just got round nd to testing it out. What can I say mate you are a star works perfect big thank you 👍👍👍👍👍👍👍😃😃😃😃😃😃😃

Sent from my HTC One using Tapatalk