Search results

Hi Aneelaj, Welcome to the Chandoo.org. If you wish, you can post a sample file with some examples for us to review. It would be great if you post the file, so that, will get a clear picture of the query. Refer: http://chandoo.org/forums/topic/posting-a-sample-workbook Chandoo, Hui &...

Hi there, Happy to post another query here. This is also the place where I am actually improving my excel skills. Thanks to that. Query: I have some multiple macro embedded excel files saved in the share drive. As I am currently working on some project, hence I keep changing the macro code...

Amazinggggg!!!! really awesome! It works like a magic for me. Thanks a lot for your help. Rgds, KK

Hi Debraj, I dont prefer datavalidation, as datavalidation doesn't work when we copy and paste the data onto the datavalidation cell right! So, I prefer a VBA code which will definately restrict eventhough the users copy and paste the data. Pls check, if it is possible. Rgds, KK

Hi there, Thanks to all of you for the support. Sorry, was giving more work to the chandoo.org. The macro tunes fine, but have found an observation that, if user copy some 3 values froms sheet2 ->(A1 - 1 B1 - 2 C1 - 3) and pasted in Sheet 1 A1 cell and again he copies the same data from...

Dam Cool:-) This is what I am looking for.... You guys are rocking. Hope one day I'll also do macros like this. ha ha ha. Thanks to all of you for your wonderful support on this. From now on, I'll keep posting and answereing queries. Rgds, KK

Hi Tanwar, Welcome to the forum. Follow the below steps: 1.Select the enter range of cells by clicking on Ctrl A 2. Go to Data Menu -> Click on Sort 3. Select purchase date from the first dropdown (check in either ascending and descending radio button next to it) Now, your data is...

Hi, Thanks for your response this. But, unfortunately this is not the answer I am looking for... I do not want to restrics only A column, I want to restrics both A and C columns. In brief, user should not be able to enter any duplicate values in the A column similarily in the B column...

Thanks mate, will try this. Rgds, KK

Hi, I know the data validation, but it doesn't work when the user copy and paste the data onto the cell. That's why i prefer to put some VBA code. Can someone help me out as requested earlier. As usual thanks much for all of your help. Rgds, KK

Hi there, We have an excel file(not shared) saved in a common shared drive where users go and update the data quite often. But, this morning we have faced a magical problem in opening that excel file. It says file is already opened by ....(user id) and asked to whether to open the file as a...

Hi Team, Can you please help me to restrict entering duplicate values in A and C column. For example, if I enter 1(A1 CEll) and 1 again in (A2) then the A2 cell should not accept and should prompt and error messages says - "Duplicate value". Same way for C column also. One more, user can...

thats fantastic. it would be great if we have a technique to paste directly without running some macros. It is difficult to set a named range for copied and cells and then select the filted range and then running macros.... oooh! Pls let me know if there is any technique to paste it in a visible...

tat works, thax a lot Luke.

Hi there, Need one more assistance on copy & pasting data. For example, I copy data from spreadsheet1 and wanna paste the data in spread sheet. The challenge is i filter some columns in the spreadsheet2 for some validations and then I wanna paste the copied data onto the filtered range...

Hi there, I have inserted some comments in a spreadsheet in A10, B11, B15, C25 and so on.... Now, i need to extract all comments in another spreadsheet or in the same spreadsheet at one shot. If possible let me know a technique to extract(something like - copy & paste) all comments with or...