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 |
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 |
All times are GMT +1. The time now is 05:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com