Cells transposing to other cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to make a cell on sheet 2 equal the contents of a cell in sheet 1 without blank cells in sheet 1 showing up as zeros in sheet 2.
 
I would like to make a cell on sheet 2 equal the contents of a cell in
sheet 1 without blank cells in sheet 1 showing up as zeros in sheet 2.
Click to expand...

In Sheet2 cell A1, put
=IF(Sheet1!A1="","",Sheet1!A1)
Then extend to the right for as many columns as you need.
Then extend that row down for as many rows as you need.
 
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

SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Update cell value based on name and specific date 1
add hyperlink using sheet names and cells(i,j) 3
Excel VBA to move cells to sheet2 based on selection in sheet1 0
cell reference 3
use month in cell date to sum all relevant cells 2
Excel Is this possible?? 3
equals merged cells 2

Back
Top