Adding records

[fracertrance]

I have a chart in a sheet in excel 2007 named Calculation.

In this sheet I have a range of fixed cells from

D5 to D14 where in I enter a code number which

can be both numeric or alpha-numeric.

Entire day I get non-stop phone calls and get group of

code numbers which can be from 1 to 10.

Whatever numbers I get I enter in this cells i.e

between D5 to D14.

For eg one phone call gives me only one number

112588. I enter it in D5 and then delete it.

Immediately second call gives me

AA334 , 1199JU , DDTJ8.

I enter it in D5 , D6 , D7 respectively and again

delete it. Third call may be eight number

VVG67 , BBHT8 , MK9908 , GTYY7 , 11478 , 33367 , SSDM90 , EMM23.

I enter it in D5,D6,D7,D8,D9,D10,D11,D12 and

then I delete it.


What I want is a code where, whatever numbers I enter in this cell

range it should keep on adding the list in other

sheet ( I have named the sheet as Record ) in one

column may be say starting from A2 in the Record

sheet.


From the above eg my Record sheet starting from A2 will

look like


112588

AA334

1199JU

DDTJ8

VVG67

BBNT8

MK9908

GTYY7

11478

33367

SSDM90

EMM23


an so on. At the end of the day I will have the list of approx

400 to 500 numbers in the Record sheet.

 

[kchiba]

Hi fracertrance,


The following file contains he VBA code, to Update records and delete the input.


Note the file format is for 2007 and above


https://dl.dropboxusercontent.com/u/48309468/UpdateRecords.xlsm


cheers


kanti

 

[fracertrance]

That was excellent but one mistake from my side

Since the chart is formula based the cells

D5 to D14 always has numbers from 1 to 10

mentioned. i.e after I get the phone call I add

say for eg one number 11456 in D5 the other cells

from D6 to D14 will have number from 2 to 10. As

the call is over I delete the number 11456 and re-enter

1 in D5.

What you have given is perfect. But when I click

UPDATE. The cells D5 to D14 becomes blank. Is it possible

that when I click update the cells D5 to D14 again

reflects from 1 to 10, Since my numbers will always be

larger then two digits. I donot mind as from the above

eg if I click update then in sheet1 I get

11456

2

3

4

5

6

7

8

10

again for eg I get three numbers 3365 , 8976 , 900

and I click update, then now my list will be

11456

2

3

4

5

6

7

8

10

3365

8976

900

4

5

6

7

8

9

10

 

[kchiba]

Hi,


Here is the link to the updated file.


https://dl.dropboxusercontent.com/u/48309468/UpdateRecords.xlsm


cheers


Kanti