Dtabase Building Copy form master sheet to multiple other sheets

Closed
Harry - Nov 6, 2016 at 07:46 AM
yg_be Posts 22692 Registration date Sunday June 8, 2008 Status Contributor Last seen April 16, 2024 - Nov 17, 2016 at 03:58 PM
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 22692 Registration date Sunday June 8, 2008 Status Contributor Last seen April 16, 2024 5
Nov 17, 2016 at 03:58 PM
Do you actually want using Excel as a database? Did you consider using other software such as Access?
0