Results 1 to 9 of 9

Need help with Calculations after copying over price and quantity

Threaded View

  1. #1
    Registered User
    Join Date
    06-23-2011
    Location
    Texas
    MS-Off Ver
    Excel 2003
    Posts
    28

    Need help with Calculations after copying over price and quantity

    This is a tough one I can't get my head around.

    I have two worksheets, one has the data the second place needs to be copied. What I need to have happen is this:

    Out of all the data on Sheet1 I need to copy over the heading in column A, price in B and quantity in C over to sheet2, but the hard part is I only need to data that has a quantity filled in. Once over on sheet2 I will then multiple price*quantity + 5% sale tax and place in column D.

    Anyone got a good idea this?

    Thanks in advance.
    Last edited by noodle48; 06-24-2011 at 09:00 PM.

Thread Information

Users Browsing this Thread

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

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