Registration whether to eat or not

KlausW

Board Regular
Joined
Sep 9, 2020
Messages
72
Office Version
  1. 2016
Platform
  1. Windows
Hi Excel helpers.

I have two sheets, called Time and Registration. Registration is a sheet with input cells in columns C, E and G. In columns B, D F and H there are formulas. In cell A2, you can choose between 25 people (initials) via a drop down. B4 to B10 show the dates for a particular week. Week number appears, via drop down, from cell G2. The input cells are thus in

C4: C10

E4: E10

G4: G10

It is thus the three areas, and not anything else, that you want to copy to sheet Time (via a button) for each new person / week selected in A2 / G2.

Sheet Time is structured as follows:

Column A contains dates (dd-mmmm-yyyy) for an entire year and column B contains the week number of the date in column A.

From column G and out to column EZ (150 in total) there is room for data for the 25 people. For each person, six columns are set aside - first person from column G: L, next person from column M: R and so on, six columns for each person. First person initials are in G1, next person initials in M1 and so on. What is entered in sheets Registration for a given person and a given date must now be copied to sheets Time in the correct cells, ie G: I for first person, M: O for second person, S: U for third person and so on. The last three columns for each person, ie J: L for the first person, P: R for the second person and so on must contain formulas, but that part does not need to include the VBA code.

All help will be appreciated.

Regards Klaus W
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Watch MrExcel Video

Forum statistics

Threads
1,127,829
Messages
5,627,143
Members
416,223
Latest member
RichardHell

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top