write formula that icludes data from sheet 1 to sheet 2 of my spr

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

Guest

I ed to write a formula on sheet 2 that includes data from cells on sheet 1
of my Excel spreadsheet. Help
 
The easiest way is to get Excel to do it.

Start entering the formula in your cell with the equal sign. Every time you need
a cell reference, navigate to it. Excel will put in the proper address.

If you insist on entering the address yourself, prefix it with the sheet name!,
as in: =Sheet1!A2
 
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

Update cell value based on name and specific date 1
Dependent drop down dynamic range formula, off sheet. 7
Vlookup and return sheet name also 2
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
using the =page! feature to transpose a row to column 0
Excel EXCEL - using a date dependant formula to hide rows 3
Losing rows that reference data from another worsheet 1
Splitting data from one spreadsheet into multiple spreadsheets 2

Back
Top