one More About Excel

Tfnx

Hello everybody,

I think I have a hard problem.
I have to export the table 17 to excel. okay, this is easy part.
but after I have to clean all data in that excel table and put formula in three columns, take the formula of row above and paste in the current row.
I no have ideia how i can do that, some one can help me, please???

thanks
God bless you all

Savatage

Tfnx wrote:

but after I have to clean all data in that excel table

If you do that , then if doesn't matter what the formula is it will be zero (blank)? :-k

Perhaps you can re-word what you are trying to do?
Do you really want to clean all the data in the table or just in the 3 Column's that has the new formula's?

If you have to clear it then why even export it in the first place?
have you tried creating a macro?

Tfnx

Hi Savatage,
Im sorry, I need to clear before export, and not the columns that have formula.
The second line in the table, have the formula, so I needo to copy of the first line, and past in the column while I have data to export.

I hope I explain you now, thanks