Search results

1) What is the file size. approx 4.6 MB 2) Does the file contains macro no macro 3) Is the file formula heavy vlookup formula & sumifs formulas there with in sheet 4) What do you mean by "Corrupt", you can not save the file, close it, re-open it & unsaved data is still there. Or You can not even...

Hi All, I have a excel file in .xlsb format located in our shared drive. and out of 10 times its corrupt almost 5 times while saving. Can anybody suggest any reasons why file corrupt so frequently ? Thanks in advance. Regards, Rajender

Hi All, Can anybody suggest if we can create a macro to create a log file with user name detail along with date and time as soon as any user save the document ? Thanks in advance. Regards, Rajender

Hi Luke, I am facing error while uploading the document here. please find the below mentioned link. https://drive.google.com/file/d/0B05F3hDqc3MoZFlpcGg4TVZRLTQ/edit?usp=sharing Regards, Rajender

Hi Luke, My active sheet is "Filter" and B6 contains the all the headers of raw data. and i want to copy all the filtered data in sheet name "filtered". Regards, Rajender

Hi Luke, After running the macro nothing is showing. only few border lines are appearing in 1st column. one more thing when i am changing range B6 to B6:Q65000 than result is showing. CopyToRange:=Sheets("Filter").Range("B6"). but i am confuse because I downloaded 1 excel file of VBA macro...

Hi All, I am new to VBA . On basis of recording and online search I created a macro but it sometimes working and sometime not. Can anybody suggest me where is the error ? I have a sheets with name 1) Issues_Tracking sheet : - All the raw data(range from A5:P65000) 2) Filter Sheet :-...

Hi All, I have an excel sheet in which I have to extract the count with having multiple conditions as follows :- 1) Main data sheet is : CD_MW_Training Plan & summery needs in sheet : Snap Shot1 2) In cell D5 & E5 I need the the sum of hours meeting creteria mentioned in D4,E4,A5...

Hi Narayan & Deb, Thanks a lot for thr solutions. Both the solutions working fine. Regards, Rajender

Hi All, Please find the link for the same. https://skydrive.live.com/#cid=393CD98CEE2A349F&id=393CD98CEE2A349F!105 I need to get the name of trainings(showing in sheet "Certification Month Wise" from range H3:T4. the result I need to get in sheet name "Final Sheet". The unique value by...