How to enter data on one sheet in excel and have it automatically added to a second sheet containing the overview of all previous entries

Basically, the pre needs to do is a note on those cells that are blank, for the cells that have and will receive the data.

there are two options, one checking if there is something in the cell, and the other just referencing (the second option is simpler, but a bunch of 0 will appear in the spreadsheet in cells that don't contain data yet).

print example:

Hi NLtL,

I've made some screenshots to clarify what I am trying to obtain:

In "Image sheet1" we have a simple table with particle sizes in one column and the column next to that needs to be filled out by the QC lab with the amount that was found in their analysis. In this case they just measured lot D

In "Image sheet2" we find that same setup, but it is an overview of all the data obtained for the lots they analysed historically.

As you can see lot D is still open on this sheet and I would like excel to add another column on this sheet with the data for lot D, once QC filled it out on sheet 1. And then again for lot E, F, etc.

So sheet 1 is the standard entry sheet and sheet 2 needs to continuously add columns once data is entered in sheet 1.

And on top of that, the average and STDEV calculations need to update along with that.

This is all very simple if you manually insert the new column into sheet 2, but I need the excel file to be validated, which means sheet 2 will be protected and cannot be manually adjusted.

Hope this makes a bit more sense

Johan

Image sheet 1

Image sheet 2

Hi André,

I've made some screenshots to clarify what I am trying to obtain:

In "Image sheet1" we have a simple table with particle sizes in one column and the column next to that needs to be filled out by the QC lab with the amount that was found in their analysis. In this case they just measured lot D

In "Image sheet2" we find that same setup, but it is an overview of all the data obtained for the lots they analysed historically.

As you can see lot D is still open on this sheet and I would like excel to add another column on this sheet with the data for lot D, once QC filled it out on sheet 1. And then again for lot E, F, etc.

So sheet 1 is the standard entry sheet and sheet 2 needs to continuously add columns once data is entered in sheet 1.

And on top of that, the average and STDEV calculations need to update along with that.

This is all very simple if you manually insert the new column into sheet 2, but I need the excel file to be validated, which means sheet 2 will be protected and cannot be manually adjusted.

Hope this makes a bit more sense

Johan

Image sheet 1

Image sheet 2

Re: add data entered on one sheet to another sheet

It can be done (automatically) using VBA code in the entry sheet.
The average calculation should only require formulas to be entered on the second sheet (no vba code). You should do that on your own.

The devil is in the details, which you haven't supplied.
Can you place a workbook with dummy data on a file storage website for download?

(maybe OneDrive)

If there are additional requirements, say so now. Don't feed them out one at a time.

'---
NLtL

https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU (free excel programs)

Hi

My name is André. I am an independent consultant.

>Without seeing the context it's a little difficult to really understand, but I ask you.

A simple reference on sheet 2 using = and pointing to the cell that will receive the values ​​I think would work.

Answer here so I can continue helping you.

André.