Search results

Thanks Debraj. Its working fine regards Sreejesh

Hi Suresh, Thanks. I need the same requirement based on multiple selection of cells. Means, i select multiple ranges and then try clt+q , then it has perform paste special values. regards Sreejesh

Hi Suresh, I need the macro to execute based on cursor selection of cells. That means, i will select certain number of rows and only for that rows, copy paste special values need to perform

Hi, I need a macro to format the cell values as paste special values based on the selection of the cells.

Thanks bigzolie, Now i need the existing contents in the rows to be copied to different sheet, if the criteria in the status column is "completed" or "C".It should also ask for pop up message like "Do you want to copy the row" , if hit "yes", it will copy and else no.

Hi I am having a data in one sheet, which will get updated everyday. In different cells i am having different machine priority list. As and when i update the data in the respective sheet, i need a button called "allocate" which when hit will allocate the respective contents in the appropriate...

Hi Suresh I tried, but its not copying the cell contents regards Sreejesh

Hi Debraj, Its showing compile error regards Sreejesh

Please help me in the below code for paste special values. Range(ActiveCell.Offset(0, -9), ActiveCell).Copy Sheets("c").Range("a65536").End(xlUp).Offset(1, 0)

Hi Bigzolie, In the attached file, if i change the M/c no: to alphanumeric ( for eg: instead of 1123, i change to 1123A025 or 1123A-025), then the formula is not working.

Sample data uploaded in http://www.2shared.com/file/JaC4evQq/test1_file.html

Hi, I am having a data in one sheet, which will get updated everyday. In different cells i am having different machine priority list. As and when i update the data in the respective sheet, i need a button called "allocate" which when hit will allocate the respective contents in the appropriate...

Hi I am having a data in one sheet, which will get updated everyday. In different cells i am having different machine priority list. As and when i update the data in the respective sheet, i need a button called "allocate" which when hit will allocate the respective contents in the appropriate...