Data Form

snjpverma

Well-known Member
Joined
Oct 2, 2008
Messages
1,094
Office Version
2016
Platform
Windows
shop name
Number of sales
ABCEDyefsd
25
koihjnmiyfv
30

<tbody>
</tbody>

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.

<tbody>
</tbody>
 
Last edited:

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,304
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

Well-known Member
Joined
Oct 2, 2008
Messages
1,094
Office Version
2016
Platform
Windows
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.
 
Last edited:

Forum statistics

Threads
1,082,570
Messages
5,366,364
Members
400,886
Latest member
Fchel

Some videos you may like

This Week's Hot Topics

Top