Hi
I attempted to search the thread regarding my questions, but I still need help.
I have an UserForm and the Userform is working to a degree. I can add data from the Userform to the spreadsheet. However the Userform, keeps overriding the last entry vs. adding a new entry.
To assist with this process, I created a Counter formula, and then added it to the VBA coding.
Page counter formula is: =COUNTA(Client!C7:C100)-1 (However, instead of counting the cells with data, it counts the blank cells, so new entry is at page 101 vs. 12)
VBA code is below:
Pls help and Thanks
Bookmarks