#1
|
|||
|
|||
Update main table when data entered in other sheet
Hello My freinds,
I facing isssue when trying make new workbook which must store our equipment operation and history log, the work book hast two work sheet, in first work sheet must be some thing like entry form, when you fill form and hit submit( I dont know other method), data must be copy in related field in second worksheet(log) which stored all equipment operation history and clear button must clean field for next entry can you kindly help me to generat the workbook the sample sheet is attached Thank you in advance |
#2
|
|||
|
|||
Hi
You could only do what you want using VBA, which I am guessing is not something you are familiar with. Equally, I don't think there is a need for this extra level of complication. I would enter data directly onto your Log sheet. In the attached file I have set up Data Validation for you so the user can only select values from the dropdown lists created on sheet Raw data. Equally, the validation has been set on the date columns such tahta date must be entered which is between the values set as Start Datae and End Date on Raw Data. When you hit the Tab button when in the Remark column of Log, a new table row is created which has the same validation as the row above. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Want to return a value from my pricing table into my raw data sheet given criteria in the data sheet | mcronin | Excel | 1 | 05-09-2016 09:43 AM |
extract specific pivot table data to a new sheet | theexpat | Excel Programming | 0 | 02-18-2016 10:08 AM |
VBA: Include Dynamic Sheet Name In Pivot Table Source Data | ibrahimaa | Excel Programming | 2 | 04-28-2012 12:27 AM |
How do I dynamically update data in a Word Document from a database table | RSchmidt | Word | 1 | 07-14-2011 04:27 PM |
Using data entered in prompt to search database table | BluRay | Word | 1 | 03-25-2011 01:47 AM |