Search results

Dear Sir, One Last query.. Tried code on actual file (copy of test.xls).. It worked but the headers are missing in output files. However, the file generated first, only one sheet shows the header rows (AUM). Not able to locate the error. Would appreciate if give logic. Attaching the original...

Dear Sir, Thank you very much..Very much appreciated.. Regards, Kundanlal

Dear Sir, Thanks for prompt reply. Actually, I am a normal user of excel who uses excel menu driven keys and some shortcuts.. Not familar with the VBA codes/program language etc. Therefore, cannot understnad what you have told me to. Will be greatful, if extend your help to sort out the...

Dear Sir, Thanks for help.. Could not login for so many days. Seen your code today. But getting some problem at my end while running the code. The output files could not be generated. Can it be possible for you to upload the same file where the code was successfully executed. Regards...

Thanks Vrunda.. This can be done.. Attached herewith a sample file which creates country wise report for sheet A1 only. Actually, I was looking for output country-wise files with all sheets with the same sheet name as of original file. Pl. see if you can help me in this. Thanks..

Thanks Vrunda..That's true for couple of occasions. If user needs to do this frequently with large file, automation is the best way which saves time and output would be 100% accurate. If u can put choice to create country-wise fle to specific field would be still better.. Thanks..

Thanks Deepakji.. Actually, need to create different files accordingly to country wise as I don't want user to see other country data. can create different files with single sheet, but not able to manage the same with multiple sheets..

All sheets of the files needs to be included in output file. The output file name be country.xls with same sheet name as of original file with the data of same country across all sheets. i.e. india.xls will consist of sheets named A1,B1,C1,D1 with a data of country India in A1,D1. Let the...

Required to create report for each country with same sheet names and data for that country.

I have taken a help from Chandoo's Portfolio Manager. The simple portfolio manager that Chandoo has designed is very good. I have a statement in pdf file where date-wise investment is listed. So as to update similar data in XLS file, I need to append this data in .pdf file into Excel. Need help pl.

thanks..

I have uploaded the file here http://www.speedyshare.com/files/24936274/kbmanwatkar_fruitbook.xlsx pl. see..Thanks...

Dear Sir, I have tried this but it is not working. I may be somewhere wrong. I did the exactly same procedure as u guided me. The file you have kept in the link is having sheet1 marked with Blue Colur and the sheet2, it is all mixed up..Pl. help me to sort this out.

Sir, I am very new to VBA. Can u pl. guide me..This may be very funny, but I need to do this.

I have a file with data in sheet1 as follows which is being updated by downloading through WEB every day. The data gets replaced for every date. Date Name of Fruit Price 10-Oct-10 Banana 12 10-Oct-10 Apple 60 10-Oct-10 Mango 100 I need to create a consolidated data for each day as...