Dtabase Building Copy form master sheet to multiple other sheets

Closed
Harry - 6 Nov 2016 à 07:46
yg_be Posts 23437 Registration date Sunday 8 June 2008 Status Contributor Last seen 6 June 2025 - 17 Nov 2016 à 15:58
Hi,

I am after some help. A bit new to Excel and only have basic skills. I am currently setting a database up and need the data on my main worksheet (Data Tab) to automatically fill out the other works sheets. I Need it to copy across based on the week number the data was entered. The format of all the sheets are the same.

The Week Number is in column A. and I have got data relating to that entry in Columns B to I.

Sheet Names I want to copy to our Week 44 right through to Week 52

Please Help



Related:

1 response

yg_be Posts 23437 Registration date Sunday 8 June 2008 Status Contributor Last seen 6 June 2025 5
17 Nov 2016 à 15:58
Do you actually want using Excel as a database? Did you consider using other software such as Access?