Transpose with cells merged and transposed it back

Hi,

Just want to ask for help.
U have 3 tabs for this file.
First tab is the original file that needs to be transposed.
2nd tab will be the result of first macro where in the data from first tab are transposed, with only one header.
I need this 2nd tab for me to be easily edit and filter the data.
3rd tab will be the next result of 2nd macro. This will be my final data after i edited the 2nd tab.

Here is the attachment.

MSPM_Forecasted_AfterHours_Summary.xls

daveglion,

Welcome to the Excel Forum.

Can we have an update to the workbook?

Worksheet After Hours will stay the same.

Worksheet Results1 will stay the same.

A new worksheet Results1_After will be what worksheet Results1 would look like after you edit the data.

And, worksheet Final will be the result of worksheet Results1_After.

daveglion,

OK. One last try.

Per your original instructions:

U have 3 tabs for this file. First tab is the original file that needs to be transposed.

The first worksheet is the raw data worksheet After Hours.

The second worksheet Results1 that you supplied is what the transposed raw data should look like after the first macro.
I can write macro1 to do this.

I need this 2nd tab for me to be easily edit and filter the data.

I need you to copy worksheet Results1 to a new worksheet Results1_After, and manually change this worksheet Results1_After per the last quote.


After you manually change worksheet Results1_After, I will write macro2 to re-organize this data to the final worksheet Final.


Can we have an update to the workbook?

Worksheet After Hours will stay the same.

Worksheet Results1 will stay the same.

A new worksheet Results1_After will be what worksheet Results1 would look like after you edit the data.

And, worksheet Final will stay the same.


If you can not supply another workbook with the four worksheets then:

In the Quick Reply box, just put the word BUMP. Then, click on the Post Reply button, and someone else will assist you.

daveglion,

OK?

I need another workbook, per my reply #4 instructions, containing 4 worksheets.

daveglion,

Thanks for the workbook.

The below macros have some error checking to see if the worksheet/worksheets exist.

To begin with worksheet After Hours must exist.

If the worksheet does esist, then run the After_Hours_To_Results1 macro.

Macro After_Hours_To_Results1 will create worksheet Results1, from worksheet After Hours .

After you edit/update worksheet Results1, then run the Results1_To_Final macro.

Macro Results1_To_Final will create worksheet Final, from worksheet Results1 .



Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

1. Copy the below code, by highlighting the code and pressing the keys CTRL + C
2. Open your workbook
3. Press the keys ALT + F11 to open the Visual Basic Editor
4. Press the keys ALT + I to activate the Insert menu
5. Press M to insert a Standard Module
6. Where the cursor is flashing, paste the code by pressing the keys CTRL + V
7. Press the keys ALT + Q to exit the Editor, and return to Excel
8. To run the macro from Excel, open the workbook, and press ALT + F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

Please Login or Register  to view this content.

Before you use the macros with Excel 2007 or newer, save your workbook, Save As, a macro enabled workbook with the file extension .xlsm


First run the After_Hours_To_Results1 macro.

Then run the Results1_To_Final macro.