Writing Macro in Excel

[jaffar]

Hi
i'm new to writing macros for an excel file.

i've a macro which will read the data from worksheets and copies that data
and paste the copied data into new workbook sheets.

it is copying the data into new work sheet. whats my problem is my original
application contains formatted data like having cloros and some of the
columns having big font size etc and some of sheets contains merged cells.
i'm totally having 8 worksheets with different layouts and the macro copying
the data into 8 new worksheets but the look and feel is not similar to the
original application. But i want as it is.
cna anyone tell me how to do this
its very urgent for me

thanx in advance
jaffar

[Kurt]

The easiest way is to start recording a macro, perform the format copy, and
stop recording. Then you can just cut and paste as needed from your recorded
macro into your own code.

...kurt

"jaffar" <[email protected]> wrote in message
news:%[email protected]...
> Hi
> i'm new to writing macros for an excel file.
>
> i've a macro which will read the data from worksheets and copies that
> data and paste the copied data into new workbook sheets.
>
> it is copying the data into new work sheet. whats my problem is my
> original application contains formatted data like having cloros and some
> of the columns having big font size etc and some of sheets contains merged
> cells.
> i'm totally having 8 worksheets with different layouts and the macro
> copying the data into 8 new worksheets but the look and feel is not
> similar to the original application. But i want as it is.
> cna anyone tell me how to do this
> its very urgent for me
>
> thanx in advance
> jaffar
>
>

[Kurt]

The easiest way is to start recording a macro, perform the format copy, and
stop recording. Then you can just cut and paste as needed from your recorded
macro into your own code.

...kurt

"jaffar" <[email protected]> wrote in message
news:%[email protected]...
> Hi
> i'm new to writing macros for an excel file.
>
> i've a macro which will read the data from worksheets and copies that
> data and paste the copied data into new workbook sheets.
>
> it is copying the data into new work sheet. whats my problem is my
> original application contains formatted data like having cloros and some
> of the columns having big font size etc and some of sheets contains merged
> cells.
> i'm totally having 8 worksheets with different layouts and the macro
> copying the data into 8 new worksheets but the look and feel is not
> similar to the original application. But i want as it is.
> cna anyone tell me how to do this
> its very urgent for me
>
> thanx in advance
> jaffar
>
>

[Don Guillett]

It would be difficult without seeing but perhaps you really should change
your layout for consistency...

--
Don Guillett
SalesAid Software
[email protected]
"jaffar" <[email protected]> wrote in message
news:%[email protected]...
> Hi
> i'm new to writing macros for an excel file.
>
> i've a macro which will read the data from worksheets and copies that
> data and paste the copied data into new workbook sheets.
>
> it is copying the data into new work sheet. whats my problem is my
> original application contains formatted data like having cloros and some
> of the columns having big font size etc and some of sheets contains merged
> cells.
> i'm totally having 8 worksheets with different layouts and the macro
> copying the data into 8 new worksheets but the look and feel is not
> similar to the original application. But i want as it is.
> cna anyone tell me how to do this
> its very urgent for me
>
> thanx in advance
> jaffar
>
>

[[email protected]]

Maybe you can copy the whole sheet to new workbook.