Copy part of workbook without losing data

[BAKABAS]

Hi,
My problem is that i wish to import data from excel spreadsheet into my accounting software, but to match the destination i need to use only the coloums that are required, thus the coloums that have my formulas contained won't be able to be imported, therfore losing my data in the coloums i need.
I would like to copy the required coloums from my workbook and paste into a new workbook so i can import.
Is there some way i can copy cell data without copying the cell formula that created the data?

Any thoughts would be warmly welcomed. I would love to overcome this problem, this would literally save me months of data entry into my new accounting software.
If you require more information, please contact me or post here.

Many thanks,

Warren
Sydney, Australia

 

[Andrew Poulsom]

Copy then Paste Special|Values will do what you want.

 

[BAKABAS]

Thanks

Dear Andrew,
Many thanks for taking the time to reply.

Your information provided was just what i was searching for.

You are a good man, i really thank you!!!!!!!!

Warren