# Problem "copying" values

#### Flash0220

##### Board Regular
Hello,

I'm having a little problem (?) copying values to a different tab on the same worksheet.

On the tab "Jaar planner" (= Year planner) the following information is entered.
Jaarplanner Andre.xls
ABCDEFGHI
801-01-0202-01-0203-01-0204-01-0207-01-0208-01-0209-01-0210-01-02
9Joe
10Jack
11William
12Averell
13Bill
14John
15Edward
16Pete
Jaar planner

In cells B8:IV8 all day's of 2002 are entered (Jan 1st to Dec 31st).

Cells A9:A53 contain various employee names.

Cells B9:IV53 contain various predefined "Work code's" like "Sales" and "Accounting".

The code's are predefined in A100:A49, and the code's are entered using "Validation".

The following information is entered on the tab "Totalen" (=Totals)

Cells A7:A56 contains the different (also predefined) work code's.

Cells B6:IV6 contains the date's Jan 1st to Dec 31st.

Cells B7:IV56 contains different calculated values.
For example in cell B7 the number of employee's are calculated, who are doing "Sales" work. (Using the COUNT.IF formula's).
The values needed to do this are on the tab "Jaar planner".

### Excel Facts

If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Hello,

Oops, apparenty the last part of my question did not appear in my previous message's.

Here's the rest and last part of my message.

The tab "Week totaal" (=Week total) contains the following information.

Cells B9:L9 contains different date's.

Cell G9 contains taday's date, (TODAY()).
Cell F9 contains yesterday's date (TODAY()-1), and cell H9 contains tomorrow's date (TODAY()+1)
There will be 5 days calculated in the past, 5 days in the future and the current date.

Cells A10:A59 contain the same "work code's" as used on the tab "Totals" (for example "Sales" and "Accounting").

Cells B10:L59 must contain different values.
For example in the "G" column (Today's date) all values have to be copied from the corresponding column (Today's date) in the tab "Totalen".
The same thing has to be done for the date's in the past and in the future.
Since the current date in column "G" changes every day, I need a formula wich searches for the corresponding value (Today's date) in the tab "Totalen" and "copies" them to the "G" column on the tab "Week totalen".
And of course the same thing has to be done for the 5 day's in the past and the 5 day's in the future.

Is there a way to do this using formula's only ?
I'm not that good in programming in VBA.

I would appreciate if anyone could help me.

Best regards,
Frits Jager

Replies
1
Views
533
Replies
0
Views
960
Replies
0
Views
421
Replies
2
Views
1K
Replies
1
Views
1K

1,218,909
Messages
6,145,166
Members
450,592
Latest member
Boulder127

### 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.

### Which adblocker are you using?

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

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