Data Entry Cell

[Alcapp]

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

[guru008]

for the data entry purpose, if you want to use single cell entry , I would suggest you to use Form functionality to the Same

Design a data entry form in Excel and setup the same according to your need.

[MarvinP]

Hi Al and welcome to the forum,

See if the attached does what you want. Enter numbers into A1 and the VBA moves them to the bottom of the numbers in the D column.

Enter numbers in A1 Only and Sum for AlCapp.xlsm

[Alcapp]

Thanks a lot MarvinP,

Is there a way of having a few of these "entry data cells" on the same spreadsheets?

I need a few for different categories.

[Alcapp]

Actually, I'll tell you what I'd like to do - Might be easier - In case you got some other ideas.

I need a spreadsheet to keep track of the footfall for the store I work at.
I need it to be easy enough so anyone can use it - it has to be divided in a few categories like "male", " female", "just browsing", etc..

My plan was to make a few "entry data cells" for each category - So the staff just has to put a number in any of them when someone get to the store. And at the end I can just collect the data for the KPIs - Not sure if it's clear enough..