Automatically Copy The Name Of The Company In Column

I have a workbook with 2 sheets; Forecast and Resources.

On the "Forecast" tabb there are 2 columns; Column A: "Company Name" and Column B: "Forecast"

The "Resources" sheet is for breaking the forecasted amount from the Forecast sheet down to the various resources who will be generating the forecated revenue. Column A lists the Company name and each column after that lists the resource.

Unfortunately, entering the data requires bouncing between the 2 sheets.

Question:

This request has 2 parts.

Part 1)
Any time a value is forecasted for a company listed on the Forecast tab, I would like the system to automatically copy the name of the company (column a) to column A of the Resource tab. (initially the row 2 as row 1 is a header, and then subsequent entries to the next available row)

Part 2)

Any time a value is forecasted, a window which lists a predefined set of resources will appear allowing the user to assign an amount to each of the resources therein AND then, when the window is closed, that data will be used to populate the corresponding row/coumn on the Resources Tab.