+ Reply to Thread
Results 1 to 2 of 2

Copy Automatically from one tab to another

  1. #1
    Registered User
    Join Date
    06-14-2021
    Location
    UK
    MS-Off Ver
    Windows 10
    Posts
    6

    Copy Automatically from one tab to another

    I am trying to build a spreadsheet to track the sales guys and their bids, approvals, and billing.

    My tab 1 is the bidding tab. This tab included all jobs they have bid and the amount the placed the bid for.
    My tab 2 is Awarded. This tab is going to be used to track once it has been approved, the purchase of parts permits, etc.
    My tab 3 is Billing. It will track what we have billed on said approved job and what is left to bill.

    I will also use my tab 1 to track the commissions for each of the sales guys.

    Is there anyone that can help me

    I need to automatically move b2 & c2 down continuously if approved and i need the approved job to automatically populate on the sales guys tab


    PLEASE HELP

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,412

    Re: Copy Automatically from one tab to another

    We would be able to understand your problem more easily if we could see how your data is laid out, so attach a sample Excel workbook. Details of how to do this are given in the yellow banner at the top of the screen. Manually indicate in your sample file the results that you want to achieve from the given data.

    Pete

+ 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. Copy Automatically from one tab to another
    By HessieNicole in forum Excel General
    Replies: 7
    Last Post: 06-16-2021, 11:06 AM
  2. Automatically copy
    By savio in forum Excel General
    Replies: 2
    Last Post: 04-06-2018, 01:48 AM
  3. [SOLVED] automatically copy data from different sheets and sequentially copy to another sheet
    By darbar76528 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 10-13-2017, 02:12 PM
  4. how to copy number automatically
    By amr7 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-21-2015, 02:52 AM
  5. Need help to create a macro to automatically copy in one sheet and copy in the other
    By Thammiraju in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-24-2014, 09:36 PM
  6. Copy and add new value to second row automatically
    By Simonee in forum Excel General
    Replies: 1
    Last Post: 10-21-2013, 06:31 PM
  7. [SOLVED] How to Automatically Copy New Data into the next sheet and have it automatically sorted??
    By ReedDOT in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-24-2013, 10:50 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