Hi Friends,
I got an excel workbook consists of 4 sheets and each sheet has got 15 columns & 100's of rows data.
Now my task is to read these columns of data from the 4 sheets and open a new excel sheet and generate a report of these values.
There is no need to insert data into a table, data from 4 sheets of data to be copied to new excel sheet as required formate with header 5 lines and footer 2 lines and inbetween data formate is needed.
And this report should be automated and able to generate a report every month.
Can you please help me to develop this program, i am new to excel programming hope this is my first program to start up. I got good skills in .net, c# programming so it will be easy for me to understand.
Please find the excel file attached, from sheet1(RawData) data is copied and generated a report which is shown in sheet5(std&qc). This report was generated manually, now we need to automate this.
If possible please send me a sample code.
Thanks for your support,
SDondeti
Bookmarks