Change Copy to Copy & Mirror Image the Copy

[mills49]

Hi
My question is, I have created a floor plan in my spreadsheet, and I am wanting to copy the floor plan layout to another sheet that will show the floor plan around the opposite way, i.e. the garages are shown on the right hand side on the original can I copy it so that the garages now appear on the left hand side ? Is that possible ?

Regards
Peter

[6StringJazzer]

How did you create the floor plan? Is it a drawing? Or borders around cells? Or something else? Can you attach your file?

No matter how you created it, I believe this will require a macro.

[mills49]

Hi
I created it by borders around cells.

[mills49]

Trying an attachment

[6StringJazzer]

Is there text as well as the borders?

Here are step-by-step instructions with screen shots.

To post a file:

1. Under the text box where you type your reply click the Go Advanced button.
2. In the next screen look above the reply box and click the "paper clip" icon. You will get a pop-up screen.
3. In the pop-up, click Add then Select to select a file from your local drive
4. Click the Upload button to upload the file
5. Click Done to attach it.

It will be displayed as an attachment underneath your post text. Alternatively as the last step you can click the Insert Inline button and a hyperlink to the file will be inserted directly into your post text in the spot where your cursor is set at the moment you click the button.

[6StringJazzer]

I was going to try to do a quick macro to do this but the merged cells and sideways text orientation complicate things a bit. Unfortunately that is more effort than I can provide.

I don't know of another way to do this but hopefully someone else can join the conversation with other ideas.

[mills49]

Hi
OK that's fine, thanks for your efforts anyhow.

Regards
Peter