2 Sheets - Input Sheet & Output Sheet - Find unique number and add value to a column

[bebongtheshark]

Hi

I basically want to automate (using macro) the inputting of certain amounts to a general output sheet using a macro. Here's my sheet and I hope you understand my imaginations

Input Sheet and Output Sheet - Automate.xlsx

[FDibbins]

If your data will be added below iexisting data, you do not need VBA for this.

This regular formula will pull out unique entries from Input sheet so AFTER sheet...

I used C2, so you can compare with your data...
=IFERROR(INDEX(Input!$A$2:$A$3,MATCH(0,INDEX(COUNTIF($C$1:C1,Input!$A$2:$A$3),0,0),0)),"")

then to get the totals...
=IF(C2="","",SUMIF(Input!$A:$A,'Output AFTER input'!C2,Input!$B:$B))
copied down

[bebongtheshark]

If your data will be added below iexisting data, you do not need VBA for this.

This regular formula will pull out unique entries from Input sheet so AFTER sheet...

I used C2, so you can compare with your data...
=IFERROR(INDEX(Input!$A$2:$A$3,MATCH(0,INDEX(COUNTIF($C$1:C1,Input!$A$2:$A$3),0,0),0)),"")

then to get the totals...
=IF(C2="","",SUMIF(Input!$A:$A,'Output AFTER input'!C2,Input!$B:$B))
copied down

Thank you very much for the formulas.

I'm not sure where to put the above formulas but technically, I only have 1 Output Sheet. I just made up two Output Sheets to show the effect of adding the inputs from the Input Sheet. Also I can't use the columns with corresponding letters (like column C) and practically, I don't have a lot of free columns as there are other formulas to it, I've used up around column ER

But I'm currently exploring your formula if it would hit my specs

[bebongtheshark]

In the Output Sheet BEFORE AB123 has a value of 90 but when the inputs from the Input Sheet is added it became 190

On the other hand, in the Output Sheet BEFORE, CD456 was not existing but after applying the Input Sheet it is added as a new line item.

All of these are happening only in one Output Sheet. So formally speaking, there is no "BEFORE" and "AFTER" sheet. The "AFTER" sheet is just an expectation of the results if we apply the fix or formula

[bebongtheshark]

Other inputs on this is also appreciated

[FDibbins]

Perhaps it might help if you provided a more realist (but still no sensitive data) example of what you are working with, how it will progress, and what you want to end up with?

(and yes,I got it that you have only 1 output sheet)

[bebongtheshark]

Thank you for your suggestions. I'm not sure if this would help and clear it up a bit. But here's a new file.

Input Sheet and Output Sheet - Add up and New Line.xlsx

1. Work Paper is already populated with details.
2. When I put entries on the input sheet and have a, say, button, the Work Paper will be populated with the details on the input sheet or new entries.
3. The result is in the ending work paper.

Not sure though, if this helps but this is my best illustration

Thank you so much for your assistance.

[FDibbins]

OK have you considered adding the new data to the bottom of the old data? That way, we can use sumif() to pull in the total data. Take a look at the 2 new tabs (red) that I added

[bebongtheshark]

OK have you considered adding the new data to the bottom of the old data? That way, we can use sumif() to pull in the total data. Take a look at the 2 new tabs (red) that I added

Hi, not sure where the two tabs are. Can't seem to find them, though on the attached file.