Hi ZAC, I have created a user form as per your needs. The shortcut is CTRL + Y and userform will pop up on this shortcut. The data will be updated on click of submit button. The fields will reset on data successfully updated.
Please have a look and let me know if any further assistance is required. It appears to me that this can be done in much better way rather than updating each value. If you have any logic to update the data from one place to another, We can help you doing same. Do let us know with relevant data, if you have any questions. Best regards, Ayush Jain Group Manager On Tue, Apr 20, 2010 at 5:25 PM, Chaudhry Zahid Ali < chaudhry.zahid....@gmail.com> wrote: > Hi Group, > > I'm working in a huge excel sheet with thousands of entries. I am currently > looking for a macro, that when invoked (upon press of a key etc) would open > a dialogue box having three fields. The first field being Select Row, In > which I can write a row number Like 3, the second filed would contain > "Replace item from column", where I can write, for example G, and the third > field containing an other "Replace item from column" for example AA. In this > case the VBA code should select cells G3 and AA3. Than when I press enter or > a button on the excel sheet the contents of cell G3 should go to AA3 and > contents of AA3 should go to G3. The dialogue should not close after the > cell contents have been replaced, but should close upon clicking the cross > because there would be mutiple entries that need correction. > > An urgent reply and help would be highly appriciated, I have very little > time to do tjis HUGE task of finding and replacing data in excel. > > Thanks in advance and Regards, > > ZAC. > -- Best regards, Ayush Jain -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Chaudhry.xlsm
Description: Binary data
