paradise
01-16-2014, 12:57 AM
Hi to all forum contributors,
Like before,this time again I am hoping for a vba excel solution to my current problem.As enclosed in my workbook which is only a sample data where I have mentioned in 'PROBLEM' highlighted with yellow only three dates which is in column A,text in column B,Numeric Value in Column C and Column D.
Likewise below just that I have higlighted in yellow-expected 'RESULT' which I have mentioned in Row 20-22.The heading are mentioned in Row 19 which would be unique i.e Tax on Purchase is unique in every date & will be header, similarly 'Excise Duty & 'Tds Payable' will be also header which will be present in Column B.But C19 and G19 are intentionally left without heading.
I want the result in the same format.OR if better format if available.
My main requirement is that I want the data to be organised datewise but rowwise just as a sample format which has been mentioned from Row 19-22 with Row 19 being header.I have also posted the same at http://www.excelforum.com/excel-formulas-and-functions/980426-arranging-row-wise-data.html#post3546951.Still it is not solved yet.
If you require further info then do let me know.
With Best Rgds,
Suresh
Like before,this time again I am hoping for a vba excel solution to my current problem.As enclosed in my workbook which is only a sample data where I have mentioned in 'PROBLEM' highlighted with yellow only three dates which is in column A,text in column B,Numeric Value in Column C and Column D.
Likewise below just that I have higlighted in yellow-expected 'RESULT' which I have mentioned in Row 20-22.The heading are mentioned in Row 19 which would be unique i.e Tax on Purchase is unique in every date & will be header, similarly 'Excise Duty & 'Tds Payable' will be also header which will be present in Column B.But C19 and G19 are intentionally left without heading.
I want the result in the same format.OR if better format if available.
My main requirement is that I want the data to be organised datewise but rowwise just as a sample format which has been mentioned from Row 19-22 with Row 19 being header.I have also posted the same at http://www.excelforum.com/excel-formulas-and-functions/980426-arranging-row-wise-data.html#post3546951.Still it is not solved yet.
If you require further info then do let me know.
With Best Rgds,
Suresh