Recent content by bsurfn99

Skip, Thanks for providing the file. I actually did rename the structured tables correctly. What I did NOT do correctly is rename my Table headers, to "ID Codes" and "Category" Once that was done everything worked great. Thank you for your insight and help! This is a powerful way to do...

Skip, yes that is what I attempted. Sorry, when I rename the tables it only selects the table contents and it doesn't seem to reference them. Andy, if you are game to showing how you connect start locations. I am attempting to take info from "inputs" @C12 and then copy and transpose them to...

Skip, Andy, Zelgar, All great responses. Thank you! I missed the email notifications due to a spam filter, but have since been playing around with the code and trying to make things work. As a general note, the location is Skip, - Your code appears to be so elegant I want to make it work...

I have been stumped by a problem, that I have created a mess of VB examples that nothing works and nothing is coming to mind, so I'm trying a clean slate to hopefully get some fresh perspective on my problem. Visually here is what I want to happen in Excel. I have 2 variable length tables that...

Perfect. Thanks for explaining the error as well.

I am looking to have a userform textbox value linked to a cell. I would like to act as default, being able to be changed by the user should they desire. I will then take the data and put it to a database. There are a lot of threads on this, but I have been unsuccessful in applying them to...

Thanks Skip!

skip, I gave your code a spin, and I may not be putting it in it's correct context. your code counts the number of rows, but how can I use this info to extract the last 5 filled rows of information? If I change your code to .select, instead of .count, it captures the whole table which would...

Thanks for your interest in helping. I do not have a date stamp, but do have an index number in column 2. I am looking for the "last 5 entries" rather than saying "find everything within a certain time period." I was planning on just modifying a loop process to find the last 5 filled rows...

I have a excel database that consists of text, numbers, and columns that are formula results. It grows by adding information on the following row. I would like to be able to extract the most recent information from it, let's say the last 5 rows and then paste that information into a different...

Just wanted to say thanks! That worked great, and it's so much simpler. thanks again. -bsurfn99

I have a script that takes textbox entries from a vbaform and finds the first blank row and places the txtbox value in the cell. What I need to do it place all form values into the same row as the first blank column. Here is a visual example of what I need database to do. column-> A | B | C...

Gerry Thanks, It works like a charm. As for permissions vs. VB, I realize that VB is limited security, the file is a low consequence, so I think the VB solution is fine. I understand that permissions would be the ideal solution, but I don't have admin access. Thanks again for your help...

I forgot to ask about your comment on "you need a reference to "Microsoft Scrtipting Runtime." What do I need to do to for this? BsurfN99

Thanks Fumei! That was exactly what I was thinking of. As far as Permissions vs. macros. I'm not familiar with how to assign permissions to an individual file in windows. I'm trying to prevent unauthorized use offsite. Could I assign Permissions in a way that would address my concerns...