I have inserted a column and just want to separate the data without deleting the table and starting over.
I have inserted a column and just want to separate the data without deleting the table and starting over.
You need to elaborate on what your problem is. Inserting a column in your table will split the table verftically. If you want to rejoin the data, click in the column Letter box at the top of the column to select the entire columm, then right click and click 'Delete' in the pop up menu.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks