Share via

copying from sheet 1 to sheet 2

Anonymous
2013-02-12T19:20:01+00:00

what formula would I use if I had sheet one with information in columns A-H and I has a date in it, I would want to move that row to sheet 2 and also if J on sheet 1 has date I would want to move that row to sheet 3.  Is there a way to automatically do this via formula?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2013-02-13T12:42:58+00:00

    Hi,

    Thank you for contacting Microsoft Community and we will be glad to assist you with your concern. As I understand, you want the data from column A-H in Sheet 1 to move to Sheet 2 and Column J data from Sheet 1 to Sheet 2.

    You may either copy and paste the data to the respective sheets or you may use the formula given below:

    ·         Go to Sheet2 in the excel workbook.

    ·         In the column A1 copy and paste the formula =IF(ISBLANK(Sheet1!A1)," ",Sheet1!A1)

    ·         To apply the formula to other columns place the cursor bottom right hand side corner of the cell and drag it to other cell.

    ·         Go to Sheet3 in the excel workbook.

    ·         In the column J1 copy and paste the formula =IF(ISBLANK(Sheet1!J1)," ",Sheet1!J1)

    I hope the above suggestion helps. If you need further assistance reply and we will be happy to assist you.

    Thank you.

    4 people found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest