how to copy data and format from sheet1tosheet2 in transpose

June 9, 2017 at 00:00:57
Specs: Windows 7
I have file containing 2 sheets,Audit and DQR sheet ,on Audit sheet i have two button 1 refresh and other save.every When we click in save data should get save on sheet2(DQR)in transpose format.

See More: how to copy data and format from sheet1tosheet2 in transpose

Report •

#1
June 9, 2017 at 04:14:04
You are going to have to provide s lot more detail. About what you are trying to do. Your subject line says "copy", your post says "save". I assume you mean that you want to Copy data from the Audit sheet to the DQR sheet and that you want the data Pasted using the Paste Special-Transpose feature.

If that is correct, then you are going to have to explain how your data is laid out on the Audit sheet, as well as what you want copied (all?) and where it should end up in the DQR sheet.

Please keep in mind that we can't see your workbook from where we're sitting, so we have no idea what your data looks like.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question