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
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