Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
data entry and saves it to sheet 2
Basically I need a simpler data entry with submit button and saves it
on the sheet 2. I have 2 sheets: 1st sheet would be entry fields that I would enter data on, such as: Account Number, Company Name, Product, etc. after entering those fields I would just hit 'submit' or 'enter' then it says on Sheet 2. I really would like to impress my boss... so your help is much appreciated. :) thanks |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
data entry and saves it to sheet 2
This would require VBA, but the actual code depends greatly on the layout of
your data. If you wish, send me direct via email a small file that clearly shows the layout of sheet 2 (column headers). Also include the headers of what you want to enter in sheet 1. Also tell me where in sheet 2 you want the data placed. For instance, do you want the data placed in the next empty row? Also, do you want to select from drop-down lists in any of the data entry cells in sheet 1? If you do, include the lists of items. My email address is . Remove the "nop" in this address. HTH Otto "YOUNGIN" wrote in message oups.com... Basically I need a simpler data entry with submit button and saves it on the sheet 2. I have 2 sheets: 1st sheet would be entry fields that I would enter data on, such as: Account Number, Company Name, Product, etc. after entering those fields I would just hit 'submit' or 'enter' then it says on Sheet 2. I really would like to impress my boss... so your help is much appreciated. :) thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data entry and saves it to sheet 2 | New Users to Excel | |||
Exporting data in Excel permanently to Access | Links and Linking in Excel | |||
Validate MsgBox Entry to Data in Cells | Excel Discussion (Misc queries) |