Macro - copy information from another sheet to current open sheet

Hello!

Just joined 10 minutes ago...

I design houses in Norway and we have rules about how much sunlight is required in rooms.
Having trouble with a calculatingprogram I created for calculating the amount of sunlight that shines in a room through windows in the outer walls.
The amount of rooms and windows varies from house to house.
I use one macro for creating a new sheet for each new room, and then in each sheet I can use a macro to add a new window.
The new window macro finds the information that is needed from a different sheet and then adds the informasjon on the next available line.
I have added ActiveSheet.Name as the sheet that the information should be pasted in to.

The problem I have is that the macros work great for the first room. When I am done with the first room and then add a new room with the room macro and then try to add a new window, the new window is added to the first room.

Here are my macros:

New room:

Please Login or Register  to view this content.

New window

Please Login or Register  to view this content.

Would appriciate any help!

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)