Data Form

[snjpverma]

[TABLE="class: grid, width: 300, align: center"]
<tbody>[TR]
[TD]shop name
[/TD]
[TD]Number of sales
[/TD]
[/TR]
[TR]
[TD]ABCEDyefsd
[/TD]
[TD]25
[/TD]
[/TR]
[TR]
[TD]koihjnmiyfv
[/TD]
[TD]30
[/TD]
[/TR]
</tbody>[/TABLE]

To fill the data in my cells I have insert "Data Form" in the Quick access toolbaar so that it is easy to do the data entry. The shop names that I need to enter is a list of few names which I need to type everytime. Can I use the autocomplete feature for the same? For e.g. if I have entered the list of all the shop names somewhere on my sheet. Now that I have the list of shop names saved somewhere and try to type the shop name in the form it should give me the auto complete option.[TABLE="width: 188"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[My Aswer Is This]

Auto complete would not be able to do what your wanting. Now I could write you a Vb script that would do what you want.
I would need to know where the value are you want entered into the activecell and its surrounding area.
For example enter all the values you want and then define that range area.
Click on the cell where you want those values pasted into and then you could using a shortcut key and those values you previous entered earlier would be entered.

I would need:
1. The sheet name where the values are entered.
2. The range name where these value are.

 

[snjpverma]

All my shops name are entered in shops!A:A and I am entering the shops name one by one in my current sheet i.e. "Self" so basically this is where I want my data entry. My data entry starts from I2 and goes down as I enter the data. and in column H i enter the sales down in that shop. Thanks for your response.