Code for Button to Submit Data to List in Numerical and Chronological Order

**swordswinger710** · 01-06-2012, 08:34 AM

Yo ho!

I have a workbook containing two sheets. An Entry Page and a Historical List. What I'm trying to accomplish is to have a code set up for the Submit button on the Entry Page which would send data entered therein to the Historical List in numerical and chronological order. I've attached the sample workbook, and I'll describe it in better detail:

Here's what should happen - a user enters the item number first in Cell B2, and the code checks if the number entered is already on the Historical List. If it isn't, the user simply enters the rest of the information, hits the Submit button, and it gets added to the Historical List in the proper place. My preferred order is shown in the Sample Workbook. If the number entered into Cell B2 is already on the Historical List, the other cells on the Entry Page would then display the most current information of that item. If the user decides to change (update) this information and then submits it, a new addition would be added to the Historical List, as is shown once again in the attachment.

Doable?

**pike** · 01-06-2012, 10:38 PM

The first step

Please Login or Register  to view this content.

then i would just filter by date

**swordswinger710** · 01-09-2012, 08:59 AM

This may seem like a dumb question, but where do I paste your code to make it work? I've hit Alt/F11 and pasted it in both sheets, the workbook, and I even tried to use it as a module, to no avail. I'm sure I'm missing something obvious, but my expertise in coding is still under construction as of yet.

Thank you for your reply, and I look forward to learning more on how to make this work.

**pike** · 01-10-2012, 05:09 AM

Try this Sample Record Workbook A.xlsm

**swordswinger710** · 01-10-2012, 10:02 AM

Pike, thank you so much, I'm getting some results now; still having a few issues though:

New items get added to the Historical List just great. The only problem being, they aren't in the right place, and I can only seem to accomplish that by doing a manual sort every time I want to see the items in the right order. Is there a better way to do this?

Also, when on the Entry Page I enter a number already listed on the Historical List, the latest information belonging to it doesn't display. Can this be done as well?

**pike** · 01-12-2012, 03:04 AM

you can record a macro of the filter process and then reuse it

**swordswinger710** · 01-12-2012, 09:37 AM

I've always wondered how the whole recording thing works, but never had it explained to me properly. What does that do, and how do I do it and make it part of my code?