Need Help - pull specific columns out of multi. rows & p

[lattelovingirl]

Here is what I’m looking to do… hope someone can help … don’t know if there is already a macro out there that does this or not …

Be able to pull information of multiple row & columns for a specified value and be able to print it in a easy to read format ….

ex.
A B C D
1 1944 a 6
2 1945 b 7
3 1946 c 8
3 1946 d 9
3 1946 e 10
3 1946 f 11
4 1947 g 12
4 1947 h 13
4 1947 I 14
4 1947 j 15
4 1947 k 16

then be able to take have a second work sheet, if that is needed, and be able to enter in one of the values for column A and have it pull the need data from the rows & columns specified.

So, you enter in a defined cell the vale of column A # 3.
result:

A C E
3 c 22
d 23
e 24
f 25

This can then be printed automatically.

Thanks for you help!

 

[Andrew Poulsom]

Re: Need Help - pull specific columns out of multi. rows &am

Try a Pivot Table with column A as a Page field, column C as a Row field and Sum of column D as the Data field. Then select the required item in the Page field and the Pivot Table will show only the data for that item.