iamno12ne1
New Member
- Joined
- Dec 18, 2013
- Messages
- 1
Hi All, I'm somewhat a newbie when it comes to macros so please bear with me.
I have an excel spreadsheet with two sheets. Sheet 1 has a 100 entries (rows 1 - 100) that are laid horizontally so they are easy to filter. Sheet 2 has the same 100 entries but are laid out vertically (columns A - EC). In short, Sheet 1 row 1 has the same data as Sheet 2 column 1 and so on.
Is it possible to create a macro so when I filter Sheet 1, the rows that I filtered are the columns that shows on Sheet 2. ie. If I filter Sheet 1 and only rows 1, 3, and 5 were left, I want columns A, C, and F to be the only columns showing on Sheet 2 (hide everything else).
I thought of using vlookup but I don't think it'll work so I thought I'd ask if there's someone out there who already created a macro or any similar solution regarding this issue. Can someone please help me? Thanks in advance.
Joe
I have an excel spreadsheet with two sheets. Sheet 1 has a 100 entries (rows 1 - 100) that are laid horizontally so they are easy to filter. Sheet 2 has the same 100 entries but are laid out vertically (columns A - EC). In short, Sheet 1 row 1 has the same data as Sheet 2 column 1 and so on.
Is it possible to create a macro so when I filter Sheet 1, the rows that I filtered are the columns that shows on Sheet 2. ie. If I filter Sheet 1 and only rows 1, 3, and 5 were left, I want columns A, C, and F to be the only columns showing on Sheet 2 (hide everything else).
I thought of using vlookup but I don't think it'll work so I thought I'd ask if there's someone out there who already created a macro or any similar solution regarding this issue. Can someone please help me? Thanks in advance.
Joe
