Hey,
I have a trial balance, I classify it at one place using a drop down list.
Say
A1 B1 C1
A A/c 1000 Debtor
B 500 Cr.
C 100 Dr.
As I get the trial balance, I feed data in column C based on the classification the data must go into.
I want to sort the data in C1, say Debtors and copy data in row A and B for the corresponding to an other sheet which has the named range debtors. I have to have them pasted there with the amount such that the total cell works the total and it can be linked to the summary. the constraints in the above, is that the data and the number of rows that need to be inserted differs. I cannot use a pivot table rep as I have to have the data in a specified order and not alphabetically and I want them in a specified area. Please help me out with the same. I hope I m clear with what I m trying to express here.
Sri
I have a trial balance, I classify it at one place using a drop down list.
Say
A1 B1 C1
A A/c 1000 Debtor
B 500 Cr.
C 100 Dr.
As I get the trial balance, I feed data in column C based on the classification the data must go into.
I want to sort the data in C1, say Debtors and copy data in row A and B for the corresponding to an other sheet which has the named range debtors. I have to have them pasted there with the amount such that the total cell works the total and it can be linked to the summary. the constraints in the above, is that the data and the number of rows that need to be inserted differs. I cannot use a pivot table rep as I have to have the data in a specified order and not alphabetically and I want them in a specified area. Please help me out with the same. I hope I m clear with what I m trying to express here.
Sri