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

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
 
You must log in or register to reply here.

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
Copying a split range 3
bookkeeping-payment confirmation 7
Can I sort and not lose reference to the cell? 3
Excel Moving data to sheet2 from sheet1 0
alter code to apply to range (links cells w/ row insertions) 1

Back
Top