Fetching values from another tab

**Kribulin** · 06-11-2008, 08:17 AM

In the first tab, I have different values for:

1)workdays
2)Saturdays
3)Sundays,

for every 0,5h.

In the second tab, I have a list with every 0,5h for one year. Now I'm trying to make this tab fetch the values from the first tab.

Thus, for instance for 2006:

*The year starts with a Sunday, so all the corresponding values for Sunday are fetched.
*Then it just goes on: fetching 5xworkday+Saturday+Sunday and so on.

Is this possible to achieve?

Basically, I want to make this "draggable", so I don't have to feed every day manually.

Sunday

=tab1!N14
.
.
.
=tab1!N61

Monday

=tab1!O14
.
.
.
=tab1!O61

Tuesday

=tab1!O14
.
.
.
=tab1!O61

.
.
.

Saturday
=tab1!M14
.
.
.
=tab1!M14

.
.
.

**VBA Noob** · 06-11-2008, 08:40 AM

Kribulin,

Please read forum rules below and then add the link to the cross post

VBA Noob

**Kribulin** · 06-11-2008, 08:52 AM

http://www.mrexcel.com/forum/showthread.php?t=324172

Sorry for my mistake.

**Kribulin** · 06-12-2008, 02:33 AM

I don't have any experience from macros, but could it be done that way? Or is there an easier solution?

**Kribulin** · 06-12-2008, 06:15 AM

Let me try to clarify it further:

In the first sheet I have the following:

Workday

00:00 value1
00:30 value2
and so on, until
23:30 value48

Saturday

00:00 value1
00:30 value2
and so on, until
23:30 value48

Sunday

00:00 value1
00:30 value2
and so on, until
23:30 value48

In the second sheet, I have [respectively want] the following:

01.01.2006 00:00 [fetch Sunday_value1]
01.01.2006 00:30 [fetch Sunday_value2]
an so on, until
31.12.2006 23:30 [fetch Sunday_value48]

I can do the first day of the year (the Sunday) manually, but then I try to create a function which repeatedly fetches the values: 5xworkday_values+1xSaturday_values+1xSunday_values for all the weeks of the year.

I hope it's clear now!

Thanks for the assistance!

**Kribulin** · 06-12-2008, 06:59 AM

I've now installed HTML Maker, but neither the "send source to clip board" nor the "View source" button work. Here are the generated files however:

From the first tab:
http://www.uploading.com/files/ZCP5Y9JX/temp_l.htm.html

And from the second tab:
http://www.uploading.com/files/F4QXB1U2/temp_r.htm.html

Hope that it's finally possible to solve! Thanks again!