Dtabase Building Copy form master sheet to multiple other sheets [Closed]

Report
-
Posts
14329
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
February 25, 2021
-
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



1 reply

Posts
14329
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
February 25, 2021
4
Do you actually want using Excel as a database? Did you consider using other software such as Access?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!