Macros to place values from one worksheet into another

[savsens]

I'm trying to write a macro that carries the cell values from one worksheet to another. It appears that since the values are placed on a different row in the new worksheet, they're not lining up properly. For example, the cell value from cell A2 in the 'workspace' sheet should be placed in cell C27 (a merged cell) in the 'agenda' worksheet. Also, additional rows may be added to the 'agenda' worksheet, so I've named the cells where the values from the 'workspace' template should start being placed (i.e. "activity" is cell C27, "page" is cell F27, etc.). When I write the macro to say Range("activity" & j) so that it copies the values from all rows, I get a range of object error. Nothing else I've tried works, Can you please help? Here's the macro and the file is attached. Thanks!

This macro places only the last row from the 'workspace' sheet into the 'agenda' sheet. I need for the values in all rows in the 'workspace' sheet to be placed in the 'agenda' sheet, starting with row 27. (Note: Copying the rows from the 'workspace' sheet will not work because I need to preserve the bold formatting in some of the cells in column C in the 'workspace' sheet.)

Please Login or Register  to view this content.

Tammy

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I will add them this time

[royUK]

Merged cells are not a good idea.

I'm not sure what you mean by having a fixed destination cell, maybe an example workbook would help.