Hello.
I am having troubles (due to lack of programming skills) with following situation.
My question is how to subtract the uniform from the "uniform table" when it is issued from the "new cadet" sheet or "issue extra uniform"?
Also, what would be the best way to add data into "Loan" sheet from the "New Cadet" sheet?
Regards, Vlad
The attached workbook is blank, could you please try attaching again?
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
For a second I thought I was blind and I didn't want to admit it.
Soz, something went wrong yesterday
Hi
I am not sure if i understand corect your requietment..., but give a try to this, in G13.
=INDEX('New Cadet'!G12:G21,MATCH('Issue Uniform'!D13,'New Cadet'!D12:D21,0))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Sorry, it doesn't work in my spreadsheet. What it suppose to do?
I thought that it going to be a macro to solve that kind of problem.
Formula works, OK, but really,i don't know if this is what are you looking for.
I am looking for a macro which will subtract qty of uniform from Uniform table, when that uniform is issued from the New Cadet worksheet (and Issue Equipment Sheet)
Have a look at the attached and see if that is what you are looking for, code bellow
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks