Enter data into a master sheet to update subsequent sheets.

Lrc1 1 Posts Saturday July 29, 2017Registration date July 29, 2017 Last seen - Jul 29, 2017 at 09:42 AM - Latest reply: vcoolio 1173 Posts Thursday July 24, 2014Registration dateModeratorStatus July 15, 2018 Last seen
- Jul 30, 2017 at 03:44 AM
I'd like to be able to enter data into a master spreadsheet which will update other spreadsheets to prevent me from having to enter the same data several times. Similar to a database but a database isn't an option.
Thanks in advance you
See more 

Your reply

1 reply

vcoolio 1173 Posts Thursday July 24, 2014Registration dateModeratorStatus July 15, 2018 Last seen - Jul 30, 2017 at 03:44 AM
0
Thank you
Hello Lrc1,

To be able to help you, we are going to need more information. Can you show us what you already have:

- Your work book and how it is set out :Master sheet and subsequent sheets.
- Any code (or formulae) that you may have or may have tried.
- Which rows of data need to be transferred to the subsequent sheets.
- Do the rows of data to be transferred have a specific criteria in a particular column to be met in order to execute the transfer?

Please upload a sample of your work book (please use dummy data) to a free file sharing site such as Drop Box, ge.tt or Sendspace and then post the link to your file back here.

Please give a clear explanation of what you would like to happen with inputs and expected results.

Cheerio,
vcoolio.
Respond to vcoolio