Replacing a Range of Cells in Excel

To attach a Workbook

(please do not post pictures of worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

You need to post a better example. To write a macro we need the actual layout of the sheets: Are those REPLACE rows in rows 1 & two or elsewhere? Column A or...?

Try this one:
(note that the sheet "header" must be present for this to work)

Please Login or Register  to view this content.

Please Login or Register  to view this content.

---

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

Open the Clipboard and copy the bottom part. Group the worksheets, delete the top part and with the active cell in the upper left corner of the area to be pasted into, click on the item in the Clipboard and paste. The pasted item will then be inserted in the same position on all the grouped worksheets. Right click on a grouped worksheet and Ungroup.