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

any updates please

Could you check https://rapidshare.com/files/1048222655/output_Cheese_Adhoc_6160.xls And do the needful for the above two request

Hi could you share you email id so that i can share my file to you. as i am no voice to micro could you just update my file like that for above two request

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

I think the server will be excess by company employee only.

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 got application define or object define error for clear contents statement regards, Pragnesh

HI, what if i convert all date in column A in to text format by having in B cell =TEXT(A1,"DD-MM-YY") and than convert it into Date. =datevalue(B1)?

Hi, Input Date should be interpreted as dd/MM/YY i.e., 2/12/2011 should be interpreted as 2nd February 2011.

Hi Narayan, When i pull all the data from various sheets it is difficult to identify correct date. because in every sheet different format are used (some are without any format just typing the date) like., 12/2/2011, 02/12/2011, 12-2-2011, Feb-12-2011 etc., So i am changing date format by...

HI Luck M, I am not able to judge where to put the above line in current macro. Could u just update the macro.

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 Luck M It is good to transfer all data at time. Here data of column H to M should be removed from sheet1 after running macro rather that it remain there.

HI Luck M this macro is right for raw 2, it need to scan every raw on by one. (Note value for C to H should be cut and pasted in next sheet) Actually i want to put Control Button in every raw of Column J, I want to press that control button to scan current raw so that selected data...

I think my problem is quite simple: Cell A2 of sheet1 should be copied to A2 in sheet2 Cell E2 of sheet1 should be copied to B2 in sheet2 Cell G2 of sheet1 should be Cut to C2 in sheet2 Cell H2 of sheet1 should be Cut to D2 in sheet2 Cell I2 of sheet1 should be Cut to E2 in sheet2 Cell J2...

hi, check https://docs.google.com/spreadsheet/ccc?key=0Apmikxh9sFKcdEpUSjhrNXZTZXFXTWNNTkFMSDNoTlE#gid=0

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, Thanks very much Cash Flow Pro. Right now i am using following macro for consolidating data form various sheets but i do not know how to use consolidation function. Sub Merge() Dim ws As Worksheet ActiveSheet.UsedRange.Offset(0).Clear For Each ws In ActiveWorkbook.Worksheets If...

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 Prasad, I have added "Dim i As Long" to third line in your given macro. And it is working for me. Kindly ignore my last comment. Thanks for your great help! Regards, Pragnesh

Hi Prasad, Thanks. I got compile error: variable not defined and it For------ i = 1 To iLstCell ----where fist i is highlighted. Regards, Pragnesh

Thanks.. i want Cells to be filled in next sheet as per number in sheet 1. if Cat food is with 2 in sheet1, i want A1 & A2 cell of sheet2 filled with Cat food. if Dog food is 4 times, i want raw A3 to A6 filled with Dog food. And accordingly.... Regards, Pragnesh