Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-21-2018, 04:56 AM
MILADREZAEE MILADREZAEE is offline Update main table when data entered in other sheet Windows 10 Update main table when data entered in other sheet Office 2016
Novice
Update main table when data entered in other sheet
 
Join Date: May 2018
Posts: 5
MILADREZAEE is on a distinguished road
Default 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
Attached Files
File Type: xlsx project.xlsx (13.1 KB, 8 views)
Reply With Quote
  #2  
Old 05-23-2018, 07:43 AM
Roger Govier Roger Govier is offline Update main table when data entered in other sheet Windows 10 Update main table when data entered in other sheet Office 2016
Novice
 
Join Date: Oct 2017
Location: Abergavenny, Wales, UK
Posts: 13
Roger Govier is on a distinguished road
Default

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.
Attached Files
File Type: xlsx project.xlsx (17.4 KB, 9 views)
Reply With Quote
Reply

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
Update main table when data entered in other sheet VBA: Include Dynamic Sheet Name In Pivot Table Source Data ibrahimaa Excel Programming 2 04-28-2012 12:27 AM
Update main table when data entered in other sheet 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft