+ Reply to Thread
Results 1 to 2 of 2

Excel Invoice Form with Button to Create Growing Database

  1. #1
    Registered User
    Join Date
    11-12-2021
    Location
    NYC
    MS-Off Ver
    Office16
    Posts
    6

    Excel Invoice Form with Button to Create Growing Database

    Hello and Good Afternoon Excel Aficionados

    Attached you are going to see the mountain I've been climbing for.... 3 weeks now.

    It is an Invoice for an Automotive Shop - All Fields seen in the invoice are supposed to be imported to a growing database.
    Yes, that is including the block of cells you see ranging B14-26 to E14-26

    The goal, is to input all fields, and then hit the "Submit Invoice" Button - and it populate to a spreadsheet.
    I have tried moving this to Access - however, the limitations of the other people who may create an invoice, does not allow for me to do so.


    I have tried running Macros that would allow this to happen
    And I keep having range issues, multiple debug issues.... I just can't do it anymore.

    Please someone help me figure this out. Please.
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475

    Re: Excel Invoice Form with Button to Create Growing Database

    -There is no sheet named "Data"

    -Your code is using named ranges, and you don't have any named ranges in the workbook

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Create customer Invoice in sep spreadsheet, using 'Create Invoice' 'Button'
    By J stacey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-10-2015, 11:45 AM
  2. How to Create an INVOICE DATABASE
    By teeonenc in forum Excel General
    Replies: 4
    Last Post: 08-04-2013, 01:09 PM
  3. Creating a macro that will copy data from an input form to an Invoice database
    By uqwee in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-10-2013, 09:07 AM
  4. Create form from excel database
    By pansovic in forum Excel General
    Replies: 3
    Last Post: 08-16-2010, 05:33 PM
  5. [SOLVED] How can I create a customer database to use with an invoice?
    By Brenda L. Carroll in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-25-2006, 02:55 PM
  6. How do I create a database from an Excel form?
    By FIRESIGN98 in forum Excel General
    Replies: 1
    Last Post: 01-05-2006, 05:00 PM
  7. Create database based on excel form
    By Pitu in forum Excel General
    Replies: 7
    Last Post: 09-29-2005, 05:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1