Weekly input to a data sheet

[EatSpork]

Hello,

I have attached a workbook that I wish to add to.

What I need is to be able to fill out the first sheet and have a database for the year take a few inputs and accumulate some of the data and slot it into an ongoing yearly database.

ie. Say the period is 13 and the week is 3 on my first page of my workbook.

G3 would be (13) and I3 would be (3). A simple IF function can point any input to another worksheet. In my case the sheet is Data 2007, (J275).


Here is where I am stuck.

If I change either G3 (period) or I3 (week) on my first sheet, how can I direct the input from the SAME input point to a different point on the database sheet?

[rylo]

Hi

Here's one option.

1) As you have a fixed output column for each of the 4 weeks, you could use a lookup to translate the week number to the output column.

2) If you have unique period numbers in column D of your output sheet, then you could use MATCH to work out which row number is the starting point for the output.

Using your example, the MATCH will return 3 which is the row number for 13 in the output sheet. Converting week number 3 to an L, you then have the reference you can use as the basis for your output.

HTH

rylo