CrystalStart
IS-IT--Management
Hi,
I need to use following to flip up data:
Selection.Copy
Range("A6").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=True
End Sub
So key word here is Transpose.
Client wants to see data flipped up.
So far I have Excel file that has Macro that runs procedure that Opens WKbook, Adds New WKbook, copying headers and refreshing query so new WKbook gets saved with new name and date.
Now, I need to run that Transpose at some point and I have never used it before.
Any suggestions on when to use it will be appreciated.
See, I have a Main workbook with headers and Macro and SP.
New book that gets data from query run by Macro - saved, closed.
I do not want to open it and copy data and Transpose to another book.
I want to do it as short as possible with minimum occurences of 'open-close-save'.
I need to use following to flip up data:
Selection.Copy
Range("A6").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=True
End Sub
So key word here is Transpose.
Client wants to see data flipped up.
So far I have Excel file that has Macro that runs procedure that Opens WKbook, Adds New WKbook, copying headers and refreshing query so new WKbook gets saved with new name and date.
Now, I need to run that Transpose at some point and I have never used it before.
Any suggestions on when to use it will be appreciated.
See, I have a Main workbook with headers and Macro and SP.
New book that gets data from query run by Macro - saved, closed.
I do not want to open it and copy data and Transpose to another book.
I want to do it as short as possible with minimum occurences of 'open-close-save'.