poojavasti
New Member
I have Excel-2007
I have entries in one sheet whose name I have given
as Records where I have 16 columns.
First column is named ProductCode which has all
numeric number which are unique. I have approx 10000+ records.
One of the column is named Qnty.
What I want is in sheet2 a userform kind of system where
I have three options
1) Code : where I will enter the ProductCode number which is
already there in Record sheet.
2) Add : where I will enter some number (can be in decimals sometimes. after decimals 2 digits).
3) Deduct: where I will enter some number (can be in decimals sometimes. after decimals 2 digits).
Last there will be Update button.
After entering the Code number I will enter some number in Add or Deduct
button. If Add then it should add that number to the existing number in the Qnty column.
i.e for eg if that matching Code has in Qnty 5 and I Add 2 and give Update then it should become 7
in Record sheet.
OR similarly may be in Deduct if I give 2 and Update then it will become 3.
BUT if in Deduct I give 6, then it will prompt me with RECORD MISS-MATCH,
since 5 is lesser than 6.
In this case I will check myself and decide what to do.
Presently I am scrolling up and down the numbers and manually adding and deducting
which is taking too much of time. This will save my time and help me to do other imp work.
If someone can provide me with the solution.
thanks
-------------------------------------
This is just an example
Code ItemName Pkd Qnty
55093 Eggs Jan-2013 5
55094 Bread Jan-2013 10
55095 Butter Jan-2013 8
55096 Oil Jan-2013 12
55097
55098
As you see every Item has a unique code.
I cannot use 55097 again for Eggs and
55098 for Bread. It has
to be used only for the product which is
new and not in the list.
I have entries in one sheet whose name I have given
as Records where I have 16 columns.
First column is named ProductCode which has all
numeric number which are unique. I have approx 10000+ records.
One of the column is named Qnty.
What I want is in sheet2 a userform kind of system where
I have three options
1) Code : where I will enter the ProductCode number which is
already there in Record sheet.
2) Add : where I will enter some number (can be in decimals sometimes. after decimals 2 digits).
3) Deduct: where I will enter some number (can be in decimals sometimes. after decimals 2 digits).
Last there will be Update button.
After entering the Code number I will enter some number in Add or Deduct
button. If Add then it should add that number to the existing number in the Qnty column.
i.e for eg if that matching Code has in Qnty 5 and I Add 2 and give Update then it should become 7
in Record sheet.
OR similarly may be in Deduct if I give 2 and Update then it will become 3.
BUT if in Deduct I give 6, then it will prompt me with RECORD MISS-MATCH,
since 5 is lesser than 6.
In this case I will check myself and decide what to do.
Presently I am scrolling up and down the numbers and manually adding and deducting
which is taking too much of time. This will save my time and help me to do other imp work.
If someone can provide me with the solution.
thanks
-------------------------------------
This is just an example
Code ItemName Pkd Qnty
55093 Eggs Jan-2013 5
55094 Bread Jan-2013 10
55095 Butter Jan-2013 8
55096 Oil Jan-2013 12
55097
55098
As you see every Item has a unique code.
I cannot use 55097 again for Eggs and
55098 for Bread. It has
to be used only for the product which is
new and not in the list.