copy several cells if one cell is set

  • Thread starter formula using percentage question
  • Start date
F

formula using percentage question

I have a worksheet that I am setting up for weekly sales of my company...
currently I have it set for each single customer, but I want to make a main
sheet so that I can enter all the weekly sales and the information for each
customer goes to their respective worksheets....
Example:
A5=Cust #, B5=Item Title, C5=Item Number, D5=EBAY or STORE, E5=Start Price,
F5=Listing Fee, G5=Pre-Pay Fee, H5=Final Price, I5=E-Place Fee, J5=Payout
What I want is that if A5=cust #1 then A5-J5 info gets copied to another
worksheet, and so forth for each customer number(2,3,4....)
How can I do this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CONCATENATE 2
Adding cells but leaving blank if not populated 2
How to simplify If / ElseIf statement 4
How to simplify If / ElseIf statement 4
formula help 3
Trouble with Cutting and Inserting a Range 2
copy several cells if one cell is set 0
multilple nested if statements in one cell 2

Top