Hi all,
I am new to VBA and i am a bit lost on a task. I need to create a table tab in the same file where i have the data, a table which will contain a only a few information (country, analysts, etc.) per project with data from a master tab. All the data is in this master tab, and i would need a VBA code to help me take some of the information i need from the this master data tab, and create a table with 5-6 projects - The table ideally will auto-fill with the necessary data as soon as i select the project name for each column. The difficulty is that while the information about each project is numerous and not in any particular order - so for the table, i would need to identify specific data (region, country, analyst, etc.) and place the information in my created table.
i am attaching a sample of the simplified excel - i hope this is clear. I would be extremely thankful for your help!!!
Thank you,
kind regards,
CM
Bookmarks