Copy part of workbook without losing data

BAKABAS

New Member
Joined
Jan 11, 2006
Messages
25
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
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
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 :)
 
Upvote 0

Forum statistics

Threads
1,213,560
Messages
6,114,309
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top