changing how tables are formattted with excel or VBA

[MarinaL11388]

Hello,

I need help with the following - I have a bunch of tables in excel but they are one under the other - instead I need the tables to be next to each other horizontally. So basically I have a bunch of tables one below the other and instead I need them to all line up on one horizontal. Does anyone have a quick way to accomplish this?

Thanks!!

Marina

 

[hiker95]

MarinaL11388,

1. What version of Excel, and, Windows are you using?

2. Are you using a PC or a Mac?

To start off, and, so that we can get it right on the first try:

Can you post a screenshot of the actual raw data worksheet?

And, can you post a screenshot of the worksheet results (manually formatted by you) that you are looking for?

To post a small screen shot (NOT a graphic, or, picture, or, flat text) try one of the following:

MrExcel HTML Maker
If you do not know how to install and how to use HTML Mr.Excel Maker
https://www.youtube.com/watch?v=JycvgGppxt0&feature=youtu.be

Excel Jeanie
Download

Borders-Copy-Paste
http://www.mrexcel.com/forum/about-board/444901-how-create-table-like-aladin.html#post2198045

To test the above:
Test Here


Or, you can upload your workbook to (the BLUE link-->) Box Net ,
sensitive data changed
mark the workbook for sharing
and provide us with a link to your workbook.

 

[MarinaL11388]

Hello Hiker,

Thank you so much for the offer to help!

https://app.box.com/s/9zbqsvc9ejkhlt5btd9wj4wcoz5fuw41

Please see what I am looking for in above link. I removed all the data but the idea is the same. Please let me know if you have any questions.

Thank you!

 

[MarinaL11388]

Some notes: I made 2 tabs one for before and one for after

Also I would need something that would move these tables from one after another to all aligned such as the example for any amount of tables with any amount of rows/columns

Thank you!

 

[hiker95]

MarinaL11388,

Thanks for the workbook.

But, there is no raw data in worksheet Before, except three cells that contain A, B, and, C?????

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[MarinaL11388]

It could be any data - I deleted all the numbers for privacy reasons. What I need is to take any set of tables that are organized such as the before - where A, B and C are one below the other and have them move into the after where A, B, and C are side by side. Does that make sense? Sorry if I am making this confusing!

Thanks!

Marina

 

[hiker95]

MarinaL11388,

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.