Here's a "Dale special"! Database Deletion in Excel

[coolcarls]

On sheet1 is my blank “input” form with a button. I enter in the data such as date & item # etc and hit the button, this then puts the data into the “Database” page and removes it from my “input” page. I also will have a summary page that is updated (I guess when the button on my “input” page is hit?”)
I now need an “output” page, this page (I’m guessing now) will be blank but have column headings, I want to enter in a list of Item #’s that are going out, and press a button which would look in the “database” page for all instances of the item #s and then bring the total number of those items that are in and available, once I confirm that the number going out is equal to or less than the number available I can press another button that will now reduce the total available in the “database”. And record the date that I pulled them out…….
Phew!!!

 

[DaleWatson123321]

Carl,

I gather that the last file I sent generated the "spark" for this posting.

After giving some thought to your above plans, I expect this should be possible using Excel's database functions.

You had sent me another file previous to the "Transfer_Data" file I sent you. Was that the same application you're developing ?

In any case, I'll be able to provide help in development of the "summary" data based on the items you specify for "output", and subtraction of those items, entry of the date taken out of inventory, etc.

However, it makes sense for the both of us to be working on the same "wavelength" - i.e. the same file. For example, I would need to know the exact "fields" you're working with, and the "record identifier" for each type of data.

If you feel you could use my help, email me the file, with a note of any modifications to your objectives.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[coolcarls]

Here's a copy of the email that I sent to Dale (incase anyone is following this thread)


Dale,
On this spreadsheet there are 2 main sheets, the “Receiving” and the “Master”. When I receive stuff I only want to enter the information one time. I also need to print a page out that I can stick on the box I just received (ID Sheet) and a page for the secretary (Receiving sheet). I would like to enter the receiving information onto the “Receiving” sheet (as it’s a familiar format here at the job). So, I would enter data in the Receiving sheet and print, open the ID and print. At sometime the data goes from the Receiving sheet onto the Master sheet and then becomes part of the database and the Receiving sheet has to be saved for future reference (just the sheet not the work book) then at sometime the Receiving sheet has to become blank and ready for the next receiving input.
Then step 2……
I need to generate some kind of pull sheet, I think it would be cool to have a dialogue box where I could enter the Item # or and it look for all instances of that item in the database (Master) and tell me the total items available, then I need to choose how many I want to ship out and have that deducted from the database, and then all the other items that are going to be shipped that day, once I have chosen all the items and quantities that are going out I can press a button and a sheet/summary is generated and I can print it out and give it to the warehouse guy to pull the stuff. Also I would like to generate summaries based on certain criteria but I was thinking I could use auto filter for that?
Well, as you will see I have just started with the code and one thing I am having trouble with is the staggered range, I was also trying to incorporate all of this with one button.