B
bmichalski
I'm new to excel macros and I'm trying to create a sheet to summarize
another one. The sheet with the data is setup like is:
Col1 Col2 Col3
R1 x
R2
R3 x
Where an x exists I want to copy column and row names into the second
sheet, so it would show:
R1 Col1
R3 Col2
Now I could go about this manually, but I'm looking at 245 rows and 2
dozen columns and a automated solutions would be a lifesaver.
Any help would be greatly appreciated!
Thanks,
Brian
another one. The sheet with the data is setup like is:
Col1 Col2 Col3
R1 x
R2
R3 x
Where an x exists I want to copy column and row names into the second
sheet, so it would show:
R1 Col1
R3 Col2
Now I could go about this manually, but I'm looking at 245 rows and 2
dozen columns and a automated solutions would be a lifesaver.
Any help would be greatly appreciated!
Thanks,
Brian