Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel Guru Needed - Help with order form that will update an inventory


21 Aug 2012   #1

Windows 8.1 Pro x64
 
 
Excel Guru Needed - Help with order form that will update an inventory

Hi,

I was hoping someone could help me with creating an order form in excel that would then update the inventory (the main reason for this is to update the inventory rather than actually store any data).

e.g.
Order for Black Collar with the name jamie - when clicking on proceed it would update the inventory minus 1 black strap and letter J, A, M, I, E

The inventory would consists of Collars, Letter and Charms.
This is where i am having real difficulty and can't figure it out as the order could be for different collar style or colors, there are 2 different letter styles (silver and colored) so the order form would need to know what set of letters to update the quantity against...

I have attached the actual excel sheet i was going to use so you can see exactly what i have got so far but it is almost an empty shell at the moment as i got stuck with this order form/updating inventory part.

As you will see when you open the excel sheet, i would like to be able use the 'Order Form' button to process the order that would then minus the QTY against the inventory.

When you click the 'Inventory' button there are 3 sections (Collars, Letters, Charms) this is where i would like the numbers to update from the 'Order Form'

I hope someone is able to help, i know its a lot to ask.

I have put description examples on the order form to try and help you understand what i am trying to achieve.

Regards,
Jamie




Attached Files
File Type: zip Inventory.zip (19.9 KB, 25 views)
My System SpecsSystem Spec
.

21 Aug 2012   #2

Microsoft Community Contributor Award Recipient

Windows 7 SP1, Home Premium, 64-bit
 
 

It's over my head, but you might have some luck at the MrExcel forum.
My System SpecsSystem Spec
21 Aug 2012   #3

Windows 8.1 Pro x64
 
 

Quote   Quote: Originally Posted by ignatzatsonic View Post
It's over my head, but you might have some luck at the MrExcel forum.
Cheers for the reply, i will look at posting there a little later in the month if i dont get any replies here or the other excel forum i have posted in (Help with order form that will update an inventory) although i haven't had anything back from them yet... /Fingers Crossed

Don't want to post it in too many places at the same time

Cheers.
My System SpecsSystem Spec
.


21 Aug 2012   #4

32bit: XP, Win7 H.P. / 64bit: 2008R2, Win7 Pro, Ultimate / Several flavors of Linux
 
 

Hello Jamie -

I'll play around with it but I think you would be better served using Access.

Regards,
GEWB
My System SpecsSystem Spec
21 Aug 2012   #5

32bit: XP, Win7 H.P. / 64bit: 2008R2, Win7 Pro, Ultimate / Several flavors of Linux
 
 

Have you tried a DuckDuckGo or Google search? See if these terms yield anything:
  • excel inventory sales spreadsheet
  • excel inventory order spreadsheet
Regards,
GEWB
My System SpecsSystem Spec
28 Aug 2012   #6

Windows 8.1 Pro x64
 
 

Quote   Quote: Originally Posted by GEWB View Post
Have you tried a DuckDuckGo or Google search? See if these terms yield anything:
  • excel inventory sales spreadsheet
  • excel inventory order spreadsheet
Regards,
GEWB
Sorry for the very slow reply and thank you for your help.

I have done a lot of searches and not come up with anything (the order form part), i think you are right with using access although i am going to have a go at setting Oracle APEX up to do the job

Regards,
JDobbsy1987
My System SpecsSystem Spec
Reply

 Excel Guru Needed - Help with order form that will update an inventory




Thread Tools



Similar help and support threads for2: Excel Guru Needed - Help with order form that will update an inventory
Thread Forum
inventory Software
EXCEL VBA 2007 Macro: Offsetting cell form a user defined selection Microsoft Office
Converting Data in tabular form to Excel s/s ? Microsoft Office
MS Excel Urgent Help Needed Microsoft Office
Opera guru needed! Browsers & Mail

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 04:08 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33