Excel help needed

alex.w

New Member
Joined
Feb 17, 2004
Messages
3
I have a 2 page spreadsheet, in which 1st sheet has the info, and 2nd has the records of withdrawals, have can enter on on one line and it would edit the quantity on the first page.
ie. item number 001 handbag quantity 1
second sheet
item number 001 quantity 1,
then it would minus the first sheet the stated quantity. it has to tally against the first sheet and item number, all primary keys. :rolleyes:

hope this makes sense
(y)
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Welcome to the Board, Alex!

Take a look at the bottom of the page for the link to Colo's HTML Maker.

It will allow you to post a representative example of your sheets, then everyone can see what your working with.

Smitty
 

alex.w

New Member
Joined
Feb 17, 2004
Messages
3
Item Code Location Item Category Allocation Status 061 test test test 5 Used
this is sheet 1 above
then on sheet two i want to put a record of withdrawal stating item code and quantity removed, thus adjusting the stock allocation on sheet 1.
i was think maybe a IF (item code = column sheet 1) then minus quantity from Sheet 1 allocation cell

hope this makes more sense
 

alex.w

New Member
Joined
Feb 17, 2004
Messages
3
I have tried to use the add in for HTML convertors and they don't work get one trust error and another version saying error 91, so please help me
 

Watch MrExcel Video

Forum statistics

Threads
1,123,318
Messages
5,600,925
Members
414,416
Latest member
Nobu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top