Report

Enter data into a master sheet to update subsequent sheets.

Ask a question Lrc1 1Posts Saturday July 29, 2017Registration date July 29, 2017 Last seen - Last answered on Jul 30, 2017 at 03:44 AM by vcoolio
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 
Helpful
+0
plus moins
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.
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!