I sure would like it if instead of the numbers "458", etc that I could enter new information from the keyboard in those places.
Lotus could do it I'll bet Excel can too.
Basically, I want to enter date hit enter move right a few times and then down left 3 cells.
Please Login or Register to view this content.
I spent all day on the web looking for this proc. I'll bet it's easy. Thanks
Last edited by alansidman; 01-30-2014 at 10:09 PM. Reason: code tags added
Why do you need a macro?
Press tab to move across columns, then press enter to move to the start column, next row.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code betweentags makes your code much easier to read and copy for testing, it also maintains VBA formatting.Please Login or Register to view this content.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(I have added them for you today. Please read all Forum Rules and comply in the future.)
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
That's almost it. I've got this crazy boss who is about to retire and doesn't want to change anything. I built a "sort" proc which is much easier than even what I'm trying to do,but lets's not spend five minutes to learn how to save 30. It's like this:
1 23 23 45 45 0
X4 Aw B2 E2 As
2 41 45 20 41 2
X2 Aw B2 C3 c2
He would have to tab, he is used to enter, he would have to do an extra tab on the letters line.
Thanks for all the help, any other ideas.
Yep it's stupid!
My numbers and letters didn't print correctly, the 1st line starting with 1 is in a cell one cell down and to the left of the X4 line.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks