push instead of pull data?

[adm]

Is there any way to push data from one sheet/workbook to another sheet/workbook, instead of just pulling it like you would normally do by using external references?

I need to have one sheet that will be read-only, and then filled in with data and constantly saved as something else, so there will be many versions of it. I then need some of the data from those sheets to be pushed into another sheet, cumulatively, so all the data from all the different versions will be available, instead of it just getting written over every time there is a new version saved.

Help!

[starryknight64]

Try this:

Please Login or Register  to view this content.

Just change the sheet name to what you want each time this macro is run.

Note: This makes another copy rather than uses a read-only sheet to do the job. Assuming you won't ever touch the duplicate, there's no need for read-only. However, (and this is out of my area of expertise) I'd try looking into setting up permissions. Not sure how to do this.

[adm]

great - thanks for your help, i'll try that!

[adm]

actually - this doesn't really help me push the data. does anyone know how to do that?

[JBeaucaire]

If you provide:

- the exact destination workbook name
- the exact destination worksheet
- the exact cell on the source sheet to push (individual and/or ranges or rows/columns...whatever)
- the exact destination on the target sheet (appended to end, where, or replace...?)

Then we can start to imagine a solution for you.

[adm]

the destination workbook name:
Meal Counts

destination worksheet:
Sheet 1

Cell on source sheet to be pushed:
B3

Cell on destination sheet:
D8 (this is the first cell that will be filled in - my goal is to have additional information, being added after, go into D9, then D10, D11, etc. I need the information that gets changed in the source sheet to be cumulative in the destination sheet, not get over-written).