I have a userform that inserts data into a table, and added a sub that sorts the list from newest to oldest. Is there anyway to insert the information to the top of the table instead? This way you don't have to scroll down everytime to find the newest addition.
Here's what I got currently
Please Login or Register to view this content.
Your above code suggests you are using a range and not a listobject(Table)I have a userform that inserts data into a table
Which is it...
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Sorry for the confusion, it's a range but mysteriously it adds it to my table so I kept it.
Assumes your data starts in A1
If not, please supply us with a sample file of your actual file setup...Please Login or Register to view this content.
Last edited by sintek; 12-15-2021 at 12:25 PM.
I'll attach it so you can see what I have.
one thing I forgot to add was one column (F) is being skipped because theres a formula in that column.
It is a listobject...
Edit...
Try this...Just check your actual order of your boxes to columns...Something seems misaligned...one thing I forgot to add was one column (F) is being skipped because theres a formula in that column.
Please Login or Register to view this content.
Last edited by sintek; 12-15-2021 at 12:46 PM.
Worked great!! Thank you!!
Glad I could contribute...Tx for rep +
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks