423,688 Members | 1,894 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,688 IT Pros & Developers. It's quick & easy.

Update Excel data using Form

P: 3
Hi,

I need to create a Form for big Excel, where I can update data using the form instead of excel.

Like we do in MS Access is there anything available like Form wizard.

As it's a big excel designing user form not possible.

Please help. Sample excel attached for reference.

Regards,

Santosh
Attached Files
File Type: xlsx LOCATION DATA_data_GP4544.xlsx (70.7 KB, 113 views)
Jan 4 '17 #1
Share this Question
Share on Google+
1 Reply


PhilOfWalton
Expert 100+
P: 1,373
It's a little difficult to establish what you are trying to achieve, but the operation looks as if it could easily be achieved using only Access.

There would be a number of interrelated tables, for example 1 for sample location where I assume the X & Y are some sort of map reference. There would be a table of Lithography. There would be a table where you entered your data. Also a table of dates as I see on the 3/11/2016 and 17/11/2016 location 16EL/16ED was surveyed with totally different results.

The advantage of Access is that much of the repeated data in your Excel sheet would only appear once.

Without knowing a lot more about your project like what is Z(At Floor) and what the Map Refs, Sectors, UG/OC Seam all mean, it is difficult to give further advice.

Phil
Jan 4 '17 #2

Post your reply

Sign in to post your reply or Sign up for a free account.