I have a price sheet. I would like to insert a quantity into one cell and have it multiply by a constant number( price). Each cell will have a different constant number.
Just enter the quantity into a cell and the product appears in the same cell. ? I have done this with VBA on a few cells but this sheet will have approx. 5-600 cells, each with a different constant value.
I'm out of ideas.
Thanks
does each cell has a unique item code?
how do you determine which price goes where?
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Each cell has a different price attached to it. I need to multiply it by a quantity. I realize now I should be trying to multiply cells between two sheets rather than to do it on one.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks