Results 1 to 8 of 8

Transfer data in cells from one tab to another tab

Threaded View

  1. #1
    Registered User
    Join Date
    09-25-2013
    Location
    Johnson City, TN.
    MS-Off Ver
    Excel 2016
    Posts
    36

    Smile Transfer data in cells from one tab to another tab

    Ok first if I do not use the right words in asking for help I am very sorry. I am trying to learn excel on my own and I am not sure what everything is called. Also I have NO clue on what you call what I am trying to do. So the title may not match what I am trying to do. All I know is I want to bring over data from one tab to another.

    I have a new spreadsheet that I made to give us the break down of each invoice we create. what we want is to see each job that is done (by code), the amount we charge per each, the cost of goods per each, and the profit margin. In this spreadsheet I have two tabs. in tab one it has the form I made that has a place to input the data that will change with each invoice as well as a section that is broken down into columns. In these columns I have it listed this way. CA=Job code, CB=Job Description, CC=how many, CD=Charge ea., CE=rate total, CF=COGS ea., CG= COGS total, CH=profit

    I have the formula done for all of the math the get the totals but what I need help with is to make it quick and simple. My idea was to make a second tab. In tab 2 I have everything listed in columns that will go into tab one. It is broken down like this. CA=Job Code list, CB=Job Description list, CC= charge ea. CD= COGS ea.

    What I want to be able to do is when I type in the job code in the first cell under the column A on tab one, it will bring over all of the info from tab 2 and put it in the right spot for that code. So if I typed in say TT001 in that cell it would bring over the description matching that code and put it in the cell under B, along with the charge in column D, and the COGS under column F. And I want it to be that way for each code I type in and it will be different each time I fill this out. How do I explain this part? Ok so I a new invoice made its # 22. I take this spread sheet and do what I want and get all the totals so I print it out. I then want to be able to clear all the info and or just type in a new set of codes that will be on invoice # 23 and then #24 etc.

    So what I am saying is the codes will be different each time I fill it out. that's why I have them listed on a different tab and will just put them in tab one long enough to get the total and print it out. Is that clear as mud? I will stop here and wait and see what questions I get back. thank you!!!! Ok I will just add the attachment to this so you can see what I am trying to do.
    Attached Files Attached Files
    Last edited by Robbyvictoryop; 09-26-2013 at 11:58 AM. Reason: Change title

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 03-18-2015, 01:00 AM
  2. Excel spreadsheet holiday to Outlook Shared Calendar and update spreadsheet
    By tigerdel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-25-2012, 06:04 AM
  3. Query excel spreadsheet to populate another spreadsheet or worksheet.
    By bsambrano in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-08-2012, 09:03 PM
  4. [SOLVED] conversion of MS Works Spreadsheet to Excel 2002 Spreadsheet
    By Kellie in forum Excel General
    Replies: 1
    Last Post: 03-24-2005, 03:06 PM
  5. Replies: 1
    Last Post: 02-08-2005, 06:06 AM

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