Fetching formulas from another tab

[Kribulin]

Sorry, it should be fetching values.


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?

 

[Kribulin]

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

.
.
.

 

[Kribulin]

Re: Fetching values from another tab

I'm not really in to macros, but can this be done in another way?

 

[Kribulin]

Any suggestions? I have asked here http://www.excelforum.com/showthread.php?t=646678 as well, without success.

 

[Kribulin]

I've been trying to create a macro, that fetches 5xworkday+Saturday+Sunday, and then repeats this cycle, but without success. But I think this would be a reasonable solution?

 

[Stormseed]

Hi, from the question you are trying to explain it seems there is a simple solution. However, members on the board find it difficult to understand your problem.

Maybe, you could explain what you need to accomplish in a better way so that the frequency of the answers to your questions could be reasonable. Take help of HTML Maker 2.42 or Excel Jeanie to shown the Excel worksheet which you are working on currently on this Board so that everyone would have a nice and close look at your problem. For getting an concrete answer to your question, it is very necessary that you explain your question properly in a nice way with tables and formulas to the point.

Click here to download the HTML Maker:
http://puremis.net/excel/downloads.shtml

Click here to download Excel Jeanie:
http://www.excel-jeanie-html.de

 

[Kribulin]

First of all, thank you for your answer. I've downloaded the suggested software and I'm trying to learn using it right now.

In the meantime: yes, the problem is very simple. I suppose even the solution might be.

So, 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 understandable now!

Thank you for helping!

 

[Kribulin]

I hope it's clear now, because I'm having some problems installing HTML Maker! (http://www.mrexcel.com/forum/showthread.php?p=1593653#post1593653)

 

[Kribulin]

Okey, I got HTML Maker running, 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!

 

[Kribulin]

Finally!

temp.xls
	L	M	N	O
13	Time	Saturday	Sunday	Workday
14	0:00	31,18	35,07	28,59
15	0:30	30,15	32,41	26,91
16	1:00	27,54	29,13	25,09
17	1:30	25,54	27,07	24,41
LOAD