Copy cell from other sheet or file

[bpinonto]

Hi,
Please help me with the followings:
1. How can I copy cell from other sheet or other Excel file?
2. Suppose that I would like to add each of the content of A1 until A10 with the content of B1 and put in C1 until C10. How can I do that?
3. What is the formula to make the rows having alternating colors? For example blue, yellow, blue, yellow, ....

Thankyou,

[Excel_Kidz]

For no1, If you want to make a copy of your worksheet to another excel file, firstly, you may open your original file which you wanted to copy and the another excel file in 1 window. Secondly, right click your worksheet tab and press "Move or Copy..." and choose your another excel file in "To Book:" and tick at the "Create a copy". :P

[inayat]

Hi,

Welcome to the forum

- If you want to copy a cell. Just highlight the cell and then press CTRL+C. Then go to the sheet where you want to paste the data and press CTRL+V.
- If you want to add let us say A1:A10. The formula will be SUM(A1:A10)
- I think that for alternate color rows there needs to be a macro. Another short cut will be to color the first two rows. Then copy the entire two rows. Right Click on the third row. Use Paste Special. Select Formats.

A little piece of advice. You could have got answers to all these questions using google... Try google search in future for all the basic questions...

[bpinonto]

Sorry I guess I didnt make myself clear.

1. Actually I want to do the followings: I have Sheet1 and Sheet2, each contains different data. The column C in Sheet1 contains the formula = 0.5*A1 - B1 (then Edit>Fill>Down). The column C in Sheet2 contains the formula =A1 + 0.7*B1. Now column D in Sheet2 has to contain the sum of column C in Sheet1 and Colum C in Sheets 2. The contents of Columns A and B in both sheets can change anytime. Is it possible to put formula in Column D Sheet2 so that when the contents of Columns A and B in both sheets changed, column D in Sheet2 automatically add column C in Sheet1 and Column C in Sheet2? If yes, how?

2. I would like to add each of the content of A1 until A10 with the content of B1 and put in C1 until C10. If I put the formula =A1+B1 in cell C1 and Edit>Fill>Down, the contents of C2 will be A2+B2, C3=A3+B3, etc. But what I actually want is to make C1=A1+B1, C2=A2+B1, C3=A3+B1, C4=A4+B1, etc. Can this be done with Edit>Fill>Down? What is then the right formula?

Thanks.

[nadarajan]

I think you have asked two question.
let me reply .
answer to first question
1.In sheet2 and in cell d1 put the forumula =SUM(Sheet1!C1+Sheet2!C1) and drag it
you will get the desired result.

2.Use absolute reference.i.e use =A1+$B$1 .Paste this forumula in c1 and drag it.

[bpinonto]

Thankyou nadarajan.
Do you have solution for my third question?

What is the formula to make the rows having alternating colors? For example blue, yellow, blue, yellow, ....

Cheers.

[tom1977]

You can use conditioning formatting with formula
look at attachment

[bpinonto]

Thanks Tom. It works.