Here is my code, I got my program to work. Instead of keypress "end". I just decided to space out enough to delete the extra id. Now....sure wish I could run this with a simple Ctrl + Z or something. It seems excel won't accept shortcut keys if i'm working in the extra window. I have to click on...
Pretty much, I'm correcting errors like Mr. Mrs. Ms. and Male or Female for a data migration to a different system. So its pretty random when it comes to what needs to be corrected. Though I have to go through a large list and multiple screens before I can even correct 1 persons profile.
So i'm...
Hmm, I guess I can do,
Row = .Cells(1, "B").Value
.Cells(1, "B").Value = Row + 1
This will keep count every time I run the micro. Keeping the place I need to be at every time I run the macro without needing a pause in a loop.
Hi Skip,
After I got back to work, I was able to use the links to figure out how to link to extra and pull data and enter data into excel and extra. I spend a few hours learning and playing around but I think I have the project that everyone was trying to figure out...figured.
I do have...
Good Morning Everyone, starting off I been notified my departments trying to see if they could pull data from Extra into Excel to work with instead of printing 8 pages every time we need to review clients. This is more of a optional side project to see if its possible.
They been looking into...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.