Can I increase the length data from a formula in a cell?

G

Guest

I have two sheets that I want to record data to each other. Sheet1 A1 cell's
information is copied over to Sheet2 A1 cell. I have done this by putting a
formula in Sheet2 A1 [=sheet1!A1]. the problem is that the formula limits the
amount of information that can be copied. Is there a way to increase the
formula size or another way to copy unlimited amount of information?
 
B

Bernard Liengme

Please expand on "the formula limits the amount of information that can be
copied"
What info are you 'copying' ?
Do you need to widen the column?
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expanding amount of data in a formula 3
Fill formula down for cells 74 rows apart 3
SUMIF function and cell /sheet reference 3
alter code to apply to range (links cells w/ row insertions) 1
Copying a split range 3
If formula-different numbers entries 2
Why does "cut and paste" cause #REF! errors? 4
Help! I am having a problem with sort! 2

Top