Hobolord
Board Regular
- Joined
- Sep 9, 2015
- Messages
- 64
<acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">Hello,
I am using Excel 2013 on Windows 7 (PC).
I have a workbook with two worksheets. On one worksheet I have 12 columns of table headers from B:M, and on the second worksheet I have a table of data from A:AD.
Ideally, when I type a word into Cell B3 of the first worksheet, select columns (B:E,G:G,I:I,M:M,O:P,S:T,V:V) from any rows with that word in column D will be populated below the headers on the first worksheet. The data in the table on worksheet 2 is a dynamic range (the amount of rows can/will change).
</acronym>Does anyone have any ideas/code to accomplish this? Please let me know if what I'm trying to accomplish is unclear.
Thank you,
Hobo
I am using Excel 2013 on Windows 7 (PC).
I have a workbook with two worksheets. On one worksheet I have 12 columns of table headers from B:M, and on the second worksheet I have a table of data from A:AD.
Ideally, when I type a word into Cell B3 of the first worksheet, select columns (B:E,G:G,I:I,M:M,O:P,S:T,V:V) from any rows with that word in column D will be populated below the headers on the first worksheet. The data in the table on worksheet 2 is a dynamic range (the amount of rows can/will change).
</acronym>Does anyone have any ideas/code to accomplish this? Please let me know if what I'm trying to accomplish is unclear.
Thank you,
Hobo
