How can I add more data to existing cells without replacing it

[Hawkmoth1]

Hello all,

I hope in the correct area with this post.

How can I easily add successive values to a cell which already contains a value, always keeping the previous value to add to?

Ideally it would be good if I could just type in a value to the cell so that it adds to the previous value.

I would need to apply this to all cells in every column (from column B) down to row 1000.

Thanks Hawkmoth 1

[CK76]

You'd concatenate additional value to existing cell value. You can do it via InputBox, cell range, array etc.

Ex.

Please Login or Register  to view this content.

But if you are going to type it in... then just double click on the cell and add your value to end of existing value...
No need for VBA.

[Hawkmoth1]

Hello CK76,

Thanks very much for your help, but I'm afraid I'm not very keyed up with the technical side of things here - are you able to please tell me in simple terms what I should actually do to achieve my goal, thanks?

Hawkmoth 1

[CK76]

Upload sample workbook with your data set (sanitized) and your expected output from your operation.

What's the purpose of the procedure and how the data may be used later.

[Hawkmoth1]

OK, actually what I need this for is very simple - I shall be creating a list of moth species (as they are recorded) in column A, then column B will have a date, e.g. the 1st. August, to which I will be adding values against each species as they are recorded. The next column will have the next date in it and so on. I may well need to add a several values against the same species on the same date. It would be good if this could be done as far down as row 1000 to accommodate a very long list of species as they are added, thanks

Example shown on the attached file shows example values against each species - please use any values you wish to for testing purposes.

Hawkmoth 1

[CK76]

Here, try this. Note that it will only activate upon double clicking on single cell. Otherwise, you can delete or update as usual.

Please Login or Register  to view this content.

Above goes into "Sheet1" worksheet module. See attached.

[Hawkmoth1]

Hello CK76,

Thanks for this, but it's not quite giving me what I require.

When I double click on a cell and enter subsequent value the cell is showing all the individual values entered. I need the cell to show the total of all the individual values each time a subsequent value is entered.

Hawkmoth 1

[CK76]

Then just change code to below. This assumes only numeric values are contained in the range.

Please Login or Register  to view this content.

[Hawkmoth1]

Hello CK76 - many thanks indeed, this has done the job just right.

I add your reputation and also the 'post as solved'.

Hawkmoth 1

[CK76]

You are welcome