data entry

I copied data from webpage that were presented in horizontal, and I want to paste them in Excel sheet in vertical. I tried (Transpose) but it did not work

Hi All I'm using cells in a worksheet for data entry (rather than a user form). User enters Name, Make and Price then clicks a command button ("ADD") to add the data to separate worksheet. It would be much quicker if the user could just use Tab key to highlight the command button (then Enter...

Hi guys and gals, I want to create a spreadsheet containing cells with fixed characters after every 5 manually entered characters: e.g. xxxxx-xxxxx-xxxxx-xxxxx-xxxxx So basically I want to type all 25 characters but have a "-" after every 5th character. Can anyone possibly assist me in doing this?

Hi everyone, Thank you all in advance for your assistance. Background: I work for a construction company and am trying to make a workbook that I can use to track the expenses incurred, deliveries received and revenues produced on a day to day basis. My goals. 1. (1) master work sheet that i...

I issued a questionnaire a few years ago and downloaded responses from the questionnaire provider into an Excel spreadsheet. I did simple analysis, no problem. I have now been asked to provide some pivot tables (crosstabs), eg gender by age. The problem is the data came down in separate columns...

Good Morning All, Can anyone provide some help? I have a userform where I want to capture data from drop down. When I submit I want to add the data to spreadsheet with additional information using vlookup based on what is submitted in form. This is what I got so far: erow =...

As stated I'm trying to move a row from one worksheet to the last row of a table on another worksheet. I'm trying to create a simple data entry sheet. I have an "Input" worksheet that has 4 "entry" rows and "Server" worksheet that has 4 tables in it that correspond with the 4 "entry" rows...

As stated I'm trying to move a row from one worksheet to the last row of a table on another worksheet. I'm trying to create a simple data entry sheet. I have an "Input" worksheet that has 4 "entry" rows and "Server" worksheet that has 4 tables in it that correspond with the 4 "entry" rows...

I want to make a form which behaves like the standard data entry form but customise the layout. Things I like about the Data Entry form: * the ability to scroll through the data * it displays the data currently in the cells * I can make changes to the data and the change is committed to the...

Good Evening, I'm hoping you can help me with this one. I'm using a userform to aid data entry...I was wondering if it is possible to attach to my button code something that saves the workbook as the value of a textbox, say for example TextBox1 so ... if i wanted to save it as a new file in...

Hi, I'm completely new to Vba, just starting playing around with it this week. My job is heavy with data entry and I'm trying to be a little more efficient. I have contact lists that live on excel spreadsheets that need to be transferred to web form and the only way of doing it is one at a time...

Hello Everyone, Just wondered if I could get some help with this one: I'd like to use this Pro tip: Add a UserForm to aid data entry in Excel - TechRepublic sheet as a template for a spreadsheet I would like to make. The userform is all good, I can edit the titles of everything and it does...

I'm writing up a note on #N/A for my students (adult office workers). I condensed the answers to students' questions into 5 paragraphs. I would appreciate any comments about mistakes or potential logical problems. Much thanks, John. #N/A – An IntroductionA display of #N/A means not available...

Hello mr excel, I have made a fairly small data entry program in excel VBA. It runs very well, but now there is need to have simultaneous dual data entry...scary stuff in excel I know! To get around having two users on one workbook at the same time, I'm simply going to duplicate the original...

Hi, I am not very good with excel hence the post. I am trying to transfer data from one workbook to another (without copying and pasting it) using some sort of V-look up formula or any other that I may not be aware of. I have given an example of the data set below: Workbook1: <tbody> A B...

I can't seem to put this question into terms that give me a result on Google; seems like an old common question from primary school! I'm getting results online that get me half way but I don't know the correct terminology to get me either further or the answer. I've tried AND and OR statements...

I'm working on a data entry spreadsheet. Basically the process needs to be - Enter Worker's Name in the first column>Manager's name is automatically entered in the second column>Area manager's name is entered in the third e.g. Joe Smith>David Jones>Mark Johnson On a separate sheet I've got a...

Hello all, this is fairly basic stuff, so please be patient with me, as i am really new to this and keen to learn. I have a spreadsheet, worksheet or whatever its best title is, which has a list of customers and details for each. I can enter data onto this sheet easily, however, I want to make...

Good day, I am trying to create an auto-generated log on a new sheet that is based off of data entered from a previous sheet. What I am wanting is when a single cell on the master sheet is modified (in this case a choice is made from a drop down list), a copy of certain cells in that row would...

Good day, I am trying to create an auto-generated log on a new sheet that is based off of data entered from a previous sheet. What I am wanting is when a single cell on the master sheet is modified (in this case a choice is made from a drop down list), a copy of certain cells in that row would...