Search results

Hi i have following macro which run in particlular book. but i want it to work at all the books of particalur folder. and want output in one file only Sub showcomments() 'posted by Dave Peterson 2003-05-16 Application.ScreenUpdating = False Dim commrange As Range Dim cmt As Comment Dim...

Hi, My Excel got hanged up due to heavy space. Could you suggest how i can remove unwanted space and reduce size? Regards, Prangesh

Hi , I want two things in my data validation file. 1. My drop down contains many values i want to quickly select values ex. I have values starting with A, B, C, D, X... I want to select values starting with X by pressing X ... same logic for all the other values. 2.New values in drop down...

Hi I want to generate report form my company system. I think it can be automated by excel macro. Following are the steps to generate report: 1. Go to Link > http://10.6.33.22/onlinetools/mis/owb%20search/OWB%20Search%20with%20Assignment%20Details.asp 2. Enter Login ID & Password...

Hi Can any one suggest in excel Calander based on week where week start from Thursday to Wednesday. Like weeek1 Thu to wed weee2 ... Regards, Pragnesh

Hi, I have one shared book having different tabs from my team member. in every Sheet i got Dates written in various forms like,,,,2/12/2011, 12/2/2011, 12-2-2011 etc......data column is always A in every sheet I want to get uniform date format from all the tabs at once.

HI, I have data in sheet1 in column A, B, C, D, E, F, G, H, I, J, K, L, M as followes: Columns as follows: Date, BROWSER, P/S/D/L/ PC class Nan Code............... EAN Code GTG/NGTG ............ IMAGE(Y/N)........... Shared country......... Char ID....................contain INDEX...

Hi I have one shared Book in which every member of my team put there data in their own sheet. ex.... Sheetx, Sheety, Sheetz etc., Every week i have to combine all the data in to one sheet or new book. Then after i am creating 4 new book form one single book. This whole process takes my...

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...

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, 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, 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, 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, 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...

Hello, If any cell contains comment(insert comment)than my output should be label of that respective column and value of fist cell of that raw. (All such comments are in sheet1) I want this output in another sheet which content address of all cells having comment in sheet1. Regards, Pragnesh