Search results

Hi, Thanks it is very good thought. Also i want to change weekNum setting. My week start form Thursday and end on Wednesday. How can i change week settings so that weeknum come as per my requirement? Regards, Pragnesh

Hi, Sheet1 Product Category-----Raw required in sheet2. Cat Food---------------2 Dog Food---------------4 Frozen Food------------3 Ambient Food-----------2 I want output in Sheet 2 for Product Category with required raw as per Sheet1: Sheet2 -Product Category Cat Food Cat Food...

Hi Hui/Narayan, I got the macro from the above link. I need following updation in that macro. 1. Output should come in the new sheet instead on new Book. Sub breakMyList() ' This macro takes values in the range myList ' and breaks it in to multiple lists ' and saves them to separate...

Special Thanks to Hui and Narayan, most awesome! My problem is resolved.....

Hi Narayan, I have data base of around 30 country. In which various information regarding products, Brand, owner and other information is given for each country. I am filtering on each country and copying and pasting it in new sheet for each country on daily basis. I want to save my...

Hi Narayan, yes ....you are right. But if i have 14 criteria to filter it takes more time compared to macro button. So i would be thinking of macro so that all data matching 14 criteria comes in 14 sheets. Regards, Pragnesh

In sheet1(column f) i have two filter criteria X/Y. I want all data filtered with Y criteria to another sheet2. and all data filtered with X criteria to another sheet3. How to do that? possible with formula or macro? Regards, Pragnesh

Hi, In Book every week new data is incorporated with data of old week. I want to get the data of only latest week in separate book without opening file. For example total data for file consist of data of week 47 + all past week data(week 1 to 46). I want to extract items of week 47 in...

Hi Luke, It is really wonderful. But i want the time details when particular folder is created. ex. i have main folder for retailer Delhaize. Now every Wednesday in this folder new folder are created so i need to note the time and date when it was created because I get many such folders...

Hi Luke M, CHARACTER TYPE -----------VALUES (FORMAT) IF WITH CUTLERY ---WITH CUTLERY CLAIM/WITHOUT CUTLERY CLAIM IF WITH FRESH PACKED CLAIM --WITH FRESH PACKED CLAIM/WITHOUT FRESH PACKED CLAIM LEVEL OF FAT CLAIM----- 23%, 60%,12% ETC MASS - WEIGHT GROSS---- 125G, 130G, 1500G NUMBER IN...

Hi Luke M u are so quick to answer that i am editing my Note and you have answered my 1st question. Thanks for grate help. Also solve my 2nd one....Lol

Hi, it it working. I have followng additional two question now: 1.I want to protect column A of sheet B where i get product coded automatically so that it can't be changed and no one can see formula in this column. (For Excel 2003) 2.I have another book where in column A i have various...

Hi, Sheet1 I have Products coded like 1234, 9809, 7987(Code of prod.).....etc in column A, Products name like...icecrem, chocolate, fruits(names of prod) ....in Column B. I want respective "product code" as output when i put "product Name" in other sheets Like if i put Fruit in 2nd...

Hi, Grate .....that's worked....Hurra! If particular folder contains 500 .JPG objects with names like for ex. like P030711_10.26...etc than i would like to reconstruct that folder with object name like for this "p030711.jpg". That means i like to reconstruct original folder containing...

Hi, I have Shared Drive having different folders for each Retailers. In each folder every day JPG (images) are loaded....like 500 objects, 400 objects etc... I want following output in excel sheet column wise without opening such folders: 1. Name of the folder in which images(JPG)...

Hi Luck M, Thanks a lot .....ignore my above note.... Now i am able to create link ..... Regards, Pragnesh

Hi Luck M, I have sheet i.e.,SUMMERISED FEEDBACK having cell address. and second sheet i.e.,FEEDBACK I want to create link in "SUMERISED FEEDBACK" Could you give me vba code accordingly..... presently i got error as variable are not defined. Regards, Pragnesh

Hi, I have cell Addresses of 800 cells of sheet2 in column B of sheet1. I want to create hyperlink at a time for all such 800 items in column B of sheet1. So that when i click on any cell in column B of sheet1....i will switch over to cell in sheet2. Any Help? Regards, Pragnesh

Hi Narayan, What i have done up to above process is got summarized validator Feedback. After that i need to discuss with validator for disagreed items for which i need disagreed items in "discussion tracker"(saperate sheet)in the form of columns like...product code, char type, old value...

Hi Narayan, Thanks a lot my issue is resolved.. Regards, Pragnesh.

Hi Narayan, I have send you mail with valditor file. and next mail with Pragneshmacro file. Kinldy look in to the matter. Regards, Pragnesh

HI Narayan, Every Friday our validator generate report form our inbuilt system in CSV and convert it in excel file. He do his validated in normal excel files having comments on shared drive which can be accessed by Indian group as well as other country group. We are just taking that file...

Hi Narayan, When i try to past lines containing comments form file created by my supervisor to our macro file i only able to past Lines only and comments are not pasted. Regards, Pragnesh

Hi, I have sheet containing comments(Insert comment) given by my supervisor. I am able to get the comments at the other sheet by running macro but i want the output without the name of Author. Ex. Sheet contains 75 Comments given by "X". so my current output is X:abc...but i want only abc...

Hi Narayan, Thanks for your Kind reply on email. My problem is really resolved. Now i am able to get Product code and Char. types. Thanks Narayan....Thanks....Chandoo.org Regards, Pragnesh