record a macro

[gray78]

I want to record a macro that when I enter data into cells,I can calculate sums and % and then when I run the macro, it will open another sheet and put all of this data into another sheet.

I will be extracting data from a database into the first excel sheet and then "exporting" this data through the macro into the second sheet.

Thanks

 

[PHV]

I want to record a macro
menu Tools -> Macro -> New macro ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SkipVought]

Hi,

A WORKBOOK contains, among other things, SHEETS.

So do you want to export to another SHEET or WORKBOOK?

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[gray78]

Skip,

I would like to export the information to another workbook

thanks