One click to update many cells

**wkp2101** · 02-15-2011, 12:26 PM

Hello, not sure if this is the correct place for this question..

I have a spreadsheet that is updated with new data weekly. Currently, I copy the row, paste a row below, then do ctrl-h to replace the old file name from last week with the new file name from this week. The cell references are the same each week, so all that needs to be updated is the file name.

Is there a way I could have 2 fields, one with the old file name, one with the new file name to be inserted, then i just click a button (update) and it automatically copies the bottom most row, pastes it one row below, and also automatically updates with the new file name?

This would need to affect multiple tabs.

Thanks!

**Leith Ross** · 02-15-2011, 12:55 PM

Hello wkp2101,

It would be helpful if you provided a copy of the workbook. Seeing the data locations and layout will speed up writing a macro and provide you with the functionality you want.

**wkp2101** · 02-15-2011, 03:42 PM

Originally Posted by Leith Ross

Hello wkp2101,

It would be helpful if you provided a copy of the workbook. Seeing the data locations and layout will speed up writing a macro and provide you with the functionality you want.

I would like to learn how to create the macro for myself. Anyway, I am attaching a modified version of the spreadsheet that will hopefully allow you to write a macro which I can then adjust for the whole spreadsheet...