Thanks Martin

It did give me an idea... But I would like to know more of it.

I don't want it hardcoded I want it variable and preferably using VBA.

In order to give an insight I shall give a sample of 1 file here.

Sales

Cost of Sales

Margin

Margin %

Each file has one sheet constituting the above info. I want in the
consolidated file the total sales, total cost of sales, total margin and
margin % to be calculated in the final sheet depending upon these figures. I
shall further clarify that the file names are not consistent and number of
files may not be the same always, it will vary month on month basis depending
upon the actual scenario.

A little more help would do my job.

Thanks in advance.

Regards
Raj

"piw3288" wrote:


How to convert lotus worksheet to excel workbook without error?


--
piw3288
------------------------------------------------------------------------
piw3288's Profile: http://www.officehelp.in/member.php?userid=6032
View this thread: http://www.officehelp.in/showthread.php?t=1319652

Posted from - http://www.officehelp.in