I have a very large and extremely complex spreadsheet (900 cells wide and 2000 long) with a design that I need to flip both vertically and horizontally.
I have manually converted the text in about 30 text boxes and then applied the 3D rotation flipping in the Y axis only. For some reason in Excel if I flip it in both the X and Y axis it doesn’t work. But when I print to pdf and then horizontally reverse it again via the pdf printer it comes out perfect.
I now have about 1000 cells (not text boxes) with text in them and I’m looking to highlight a cell and run a macro that cuts the cell text, pastes it into a text box in that cell, and then flips the 3D rotation by 180 degrees.
Have spent a week trying to find something and having no luck.
Any help will be much appreciated.