Data transfer from sheet to sheet with Formula

**Clayton27** · 08-13-2012, 11:56 PM

Hi Everyone,

Been trying to find a solution to this for a while now, would really appreciate someone working it out for me.

Is what I would like to happen is have each colored section appear on today's call sheet as the date changes.

So today's date being the 14/08/2012, then the information from sheet "Bayswater" the 12 orange rows(2-13) will appear in today's call sheet.

When it clicks over to tomorrow 15/08/2012 then the following 12 rows(14-25) on "Bayswater" will appear in today's call sheet.

I would like to select which sheet and rows the information comes from when each date occurs, so the 27/08/2012 might be "Croydon" rows 26 to 37.

Call sheet.xlsx

Thanking you in advance.

Clayton

**sunil.excel** · 08-14-2012, 12:23 AM

Try this....

**Clayton27** · 08-14-2012, 01:23 AM

Hi Sunil,

Appreciate you coming back to me so fast, is it possible to have it relative to the date sheet I had on there or not?? I don't want to have to input any data each day, I need this for my other guys on the road and they wouldn't enter any information on it, so it needs to be automated if possible.

thanks.

Clayton

**sunil.excel** · 08-14-2012, 05:48 AM

Not getting...

**Clayton27** · 08-14-2012, 06:20 AM

On the first sheet in the work book, it's titled Dates and as the day changes from one to the next today's date is highlighted through conditional formatting.

What I would like to have is customers I select from the other work sheets to appear on Today's calls in accordance to dates I select, so if i call on one group of customers every quarter I'd like to select which date they would appear in today's calls every quarter or every Tuesday.

Does this make sense?

Regards,

Clayton