data based on date

[penguinspeaks]

I am going to try my best to explain what I need help with.

I have a date in a cell, say a1. I do a vlookup to get the week number based on that. so currently, week number is 32.

i have a table (array) that has totals for each day of the week. this has many rows, as each week has it's own row.

I have another sheet that the daily totals are entered into.

so let's say i enter 1234 into cell b:24 after i enter that, it needs to be copied into the table that i have in it's appropriate cell, based on the week number.

so if it is week 32, it copies into c:g55 if it is week 33, it copies into c:g56 and so on. I know I can write a macro to do this, but I want to have, i guess an embeded macro? There is much more than just the daily number, which is why I need this to happen automatically.

So to set this sheet for the following week, all i have o do is change the date, and it would be ready for the new week.

If someone can understand this, and can help, I surely would appriciate it.

Bam

 

[SkipVought]

Hi,

Seems to me that this kind of thing is best handled by a Query that uses the table with the data that you entered the 1234 in B24 and returns the resultset to the sheet containing the week by week summary. Or it could even be a PivotTable, rather than a query. No VBA required.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[penguinspeaks]

pivot table. interesting.

I am a former Lotus guy, and have come a long way into excel. I will look into that.

thanks