Results 1 to 8 of 8

How to get info from one sheet to another automatically in a workbook without vlookup

Threaded View

  1. #1
    Registered User
    Join Date
    01-03-2017
    Location
    Arkansas
    MS-Off Ver
    2016
    Posts
    11

    How to get info from one sheet to another automatically in a workbook without vlookup

    Good morning,
    I have posted this before but maybe I didn't work it right or something. This is due wednesday and I'm very stuck. I'm attaching my workbook, what I am trying to do is create an invoice tracker for this company. On the Invoice Main tab the assistant creates an invoice which then the technician can fill out on the Invoice tab, the drop downs take them to their invoice and then they fill in what they sold. How the technician gets paid is based on the hours sold, so I included that. Now where I am stuck is, I can't figure out how to get those hours sold from the Invoice tab to pull over automatically to the Hours Sold tab. They want it to calculate per invoice and also calculate totals.
    I was thinking a simple vlookup to pull over but based on what? the sheets have nothing in common except the invoice number but that is in the drop downs of the Invoice tab not on the rows themselves.
    It's ok if I need to redo something to make it work or even revamp the entire workbook, I'm open to any and all suggestions. This is time sensitive so if you can help, please do! I'd greatly appreciate it, thanks!
    Attached Files Attached Files
    Spryng (like the season)

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Ad hoc request form info sent automatically to another workbook
    By V.Cell in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-21-2015, 12:56 PM
  2. automatically move info to another sheet?
    By welsh_decs in forum Excel General
    Replies: 12
    Last Post: 11-25-2013, 10:30 AM
  3. Replies: 3
    Last Post: 11-23-2013, 03:28 AM
  4. Saving info from outlook mails automatically to a workbook
    By Bishonen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-06-2013, 09:25 AM
  5. [SOLVED] Macro That Automatically Copies Row from Sheet 1 into Sheet 2 Based on Info in that Row
    By smartmika in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-27-2012, 10:52 AM
  6. how do I update a sheet automatically with the info from another?
    By Richard in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 04-21-2006, 03:25 PM
  7. parse info. from one workbook to another automatically
    By spirosu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-15-2006, 06:10 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