Hi everyone,
I got a question, was not sure where to ask, in formulas or VBA.

I would like to enter data through a single cell - so when I put data into it and press ENTER, the content disappears and the data is sent to another cell where it's added (not sure if it's clear)

I got a VBA code to delete the cell after pressing ENTER,

"Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
Target.ClearContents
Application.EnableEvents = True
End Sub"

But I dont know how to send these data to another cell.

Anyone git an idea?

Thanks a lot