Hi
I am looking for a way to enable fast data entry whereby a single character (between 0 and 9) is entered into a cell and the cursor then moves to the adjacent cell without having to hit Enter or Tab. I looked at Data Forms but those require a tab to move to the next field. I tried Worksheet Change Event but it still requires me to hit Enter after typing in the single character into the current cell to get to the adjacent cell.
Each record has about 30 cells line up horizontally and each cell contains a single character between 0 and 9. There are a thousand records in one worksheet that require similar data entry hence having the capability I just described will make life a lot easier for the data entry folks.
Any help or suggestion is much appreciated.
Phil
Can someone help me with this. I enter lists of number sometimes the same repeatily in column. Like G17 would be 76.2 and G18 and G19 are the same. Can set code to look at the cell above and copy it if no data is entered? We go right to left, our move selection after enter is right, just though this might be helpfull.
Thanks
Argh! I need help:
I have written a macro to access data for me online. However, some of the pages I access do contain the data. In this case, i need to be able to to handle the error when my macro doesnt find it. Normally the macro would be extract a particular number from the data but if the data is not there, i need the macro to ignore the error, move on to the next function and enter "640" in excel where it would have entered the data that was to be extracted.
Any ideas?
Hi all - Hope someone on here can help me please!
A friend (who lives a fair distance away) has a very simple Excel 2007 spreadsheet. It consist of four columns with either numeric or alpha data in the. No formulas, no macros etc...
She emailed the spreadsheet to me and it works fine, I can enter data without problems. Whenever she tries to use it she just can't enter any data. She clicks in a cell and it higlights but she doesn't get a cursor and can't enter data. If she tries to click in the area underneath the toolbar to enter data she also does not get a cursor!! It used to work just fine for her but has suddenely stopped!
Any ideas please?
This is what I'm trying to do:
Based off one cell that has abbreviations entered, I want to have it automatically enter the full names in the other cell in that row.
For Example:
If I enter, BEF-DK in cell G2, I want that to automatically enter Belfield in cell D2, and Dickinson in cell E2.
Is this even possible to do?
Thanks for your help!
I have been asked if there is a way to search through a folder which contains a number of Word documents (all the same format but containing different data).
Extract all data entered in various cells within a table layout e.g. data in cell following the one containing the words Item No and then following the cell containing Details of Nonconformity.
Then paste the data into an Excel worksheet by row. Each row containg a set of data from each document.
Documents are named in sequential order e.g. 0001, 0002, 0003
Source directory is named O:\QUALITYCONTROL\SNPF - Syspro.
There are circa 500 documents to go through s any help to reduce the time spent doing this would be very much appreciated.
Kind regards
Bernard
Hoping someone can help me out with this conundrum. I am unable to enter any letters or numbers into cells. I can copy data into cells, change fill colors of cells and make some other fairly useless changes but when I enter anything into a cell after I press Enter the cell appears blank. Very frustrating, please help.
I want to create a user form from which I want users to post data to another excel files which is formatted as a table. Is it possible to post data to a closed workbook, and if yes what codes can i use?
Thanks
Hi,
I would like to know how to have excel enter text data automatically.
Here is my problem. I have Column A with numerical data. And I want excel to determine if the number is a certain number in cell A2 to enter certain text in cell b2.
For example: If A2 = 2042 then in B2 enter "INTW" or
If A2= 2043 then in B2 enter "INTV" or
If A2=2060 then in B2 enter "TCSW"
Is there a way to do this?
I tried to do search but I am not exactly sure of what I am looking for or if it is at all possible.
Thank you in advance for any and all assistance.
I currently have an excel sheet whereby you can enter a number into cell D5, and a result is displayed on a popup userform.
Would there be anyway as to publish this sheet as a webpage whereby the data can be entered exactly the same as it is in the sheet in excel?
