1 Replies - 442 Views - Last Post: 03 June 2013 - 12:19 PM Rate Topic: -----

#1 AnalyticLunatic   User is offline

  • D.I.C Lover

Reputation: 239
  • View blog
  • Posts: 1,073
  • Joined: 25-June 12

Excel Worksheet Data Input-Review-Convert

Posted 03 June 2013 - 07:09 AM

  • I have an Excel Spreadsheet file.
  • One of the tabs acts as a "Form". This form allows users to fill out an inspection.
  • When users are filling out the form, other tabs in the worksheet act as look-up tables. This helps the user quickly fill-in some sections.
  • One of the tabs acts as a data table, to store what is entered into the form.
  • What I need to do is code 5 command "buttons" on the main form tab. A "NEXT", "PREV", "CLEAR", "SAVE" & "CONVERT".
  • NEXT & PREV need to cycle up and down through the "data table" page, displaying that records information on the main form as records are cycled through.
  • SAVE needs to save what is entered on the main form to the next available row on the "data table" page.
  • CONVERT needs to take all records in the "data table" page and place them in a dBase (.DBF) file.
  • CLEAR as in all programs needs to clear the form for new entry.

Hopefully someone can help me with this. I've never set up buttons or any kind of coding on an Excel Spreadsheet before...

Is This A Good Question/Topic? 0
  • +

Replies To: Excel Worksheet Data Input-Review-Convert

#2 modi123_1   User is online

  • Suitor #2
  • member icon

Reputation: 14691
  • View blog
  • Posts: 58,720
  • Joined: 12-June 08

Re: Excel Worksheet Data Input-Review-Convert

Posted 03 June 2013 - 12:19 PM

Woah.. let's not start duplicate posting, cross posting ,etc. Closing.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1