Thanks Ayush, it works nicely now. I received a mail from your personal address and I replied without checing the address thats why this happened. Any how, will be more careful in the future. :-)
Thanks again for all the help..... On Tue, Apr 20, 2010 at 6:34 PM, ayush jain <jainayus...@gmail.com> wrote: > > Hi Chaudhary, > > Please note that you should keep our Group email address in all > communications. It will help you. > > I have modified the macro to swap the values. Have a look and it should > work now. Let me know if any further assistance is required. > > The logic based updation of data is possible and someone in group should > help you out on same, Please submit a separate query with detailed example. > > > Best regards, > Ayush Jain > Group Manager > > On Tue, Apr 20, 2010 at 8:38 PM, Chaudhry Zahid Ali < > chaudhry.zahid....@gmail.com> wrote: > >> Dear Ayush, >> >> Thanks for the file. But the problem is that when it updates Data from A1 >> to B1, the data in one of the cell's changes but the data in the other >> cell remains the same. Hwat I need is, suppose, A1 has a value of 100 and B1 >> has a value of 200, when I click submit, B1 should show 100 and A1 should >> show 200. >> >> And yes you are right, the data that I have has a trend to follow, but the >> issue is that there are too many variables to follow. Still I am sending you >> two rows from the data (From over 7000 rows), the pink values need to be >> max within the seven day period, than comes green values and finally the >> blue ones. The white value preceeding the blue value needs to be less than >> the blue value and the white value after the green cells needs to be less >> than the green value. The other two values in the week can have any value >> but should be less than the value in highlighted color. I hope you get the >> idea. >> >> Thanks for sending me the macro and I'll highly appreciate if you can send >> me the adjusted macro or if you can send me any macro or formula which can >> follow and solve the problem in above para. >> >> Thanks and Kindest Regards, >> >> ZAC >> >> >> >> >> On Tue, Apr 20, 2010 at 5:27 PM, ayush jain <jainayus...@gmail.com>wrote: >> >>> 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 >>> >>> >> > > > -- > Best regards, > Ayush Jain > > > > > -- > 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 > -- ---------------------------------------------------------------------------------- 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
