Hi

If you want to get information from say sheet1 into sheet2, then in sheet 2
you could put a formula like

=IF(Sheet1!A1="","",Sheet1!A1)

in cell A1 and then drag down and across as needed.
But bear in mind this is very different from copying, because if the data
changes in sheet 1 it will also change in sheet 2.

The only way to copy data is to use copy and paste as far as i know.

--

_______________________
Naz,
London
www.LivingWandsworth.co.uk


"Having Issues" wrote:

I know this should be easy, but I haven't done formulas for a while.

I am trying to copy top to bottom of a spreadsheet via formulas instead of
copying and pasting them.

General idea:
If a cell is blank, leave it blank but if the cell contains any data, copy
the data.
--
Thank you
Having Issues