Question about Business & Productivity Software

Re: Excel formula

Hi, I am not really sure if I get your exct meaning, so would I be correct in saying that you wish to copy all the data and structure from DCT INFO across to DCT. If this is correct so long as the dollar data is formatted in the first worksheet to currency then when it is pasted it will maintain its formating into the next sheet.

One question though...Do you wish to change the data on the DCT INFO sheet and wish it to be automatically changed in the DCT sheet?

If yes then you will have to write the following formula into the DCT cells:- =DCT INFO!A1 (where A1 is the first cell of data in sheet DCT INFO that you wish to duplicate.) You can then use auto fill by selecting the cell you just typed the formula in to and then placing the cursor onto the small black square in the righthand bottom of the cell and clicking the left mouse button and holding and dragging down to whereever your data ends. For example A30. Repeat this with the column B.

Let me know if tis is not entirelt what you require and I will try to help further.

Regards

SeaJade

Posted on Mar 17, 2008

Go to the cell you want this total in.

Type this formula:

=SUM(IF(Sheet2!C1:C10="EME",IF(Sheet2!N1:N10=1,1,0)))

make sure you end the formula with CTRL - SHIFT - ENTER which makes it an array formula. If you forget, go back to the cell with this formula and press F2 (to edit the cell) and press CTRL - SHIFT - ENTER to convert it to an array formula (Excel will show a little {...} around the formula).

Type this formula:

=SUM(IF(Sheet2!C1:C10="EME",IF(Sheet2!N1:N10=1,1,0)))

make sure you end the formula with CTRL - SHIFT - ENTER which makes it an array formula. If you forget, go back to the cell with this formula and press F2 (to edit the cell) and press CTRL - SHIFT - ENTER to convert it to an array formula (Excel will show a little {...} around the formula).

Dec 21, 2008 | Microsoft Excel for PC

Hello cbw@netzero.com,

The source code request would be for a program code, appropriate if you actually wrote the code for the Excel program, but if you are copywriting a set of formulas or an excel execution sequence, then you want to print your formula view for copywriting.Excel has a Formula View that shows the formulas on your worksheet rather than the results of those formulas. You toggle between Formula View and Normal View by pressing CTRL ~ on your keyboard. Just toggle to formula view and print your worksheet to see all of your formulas.

Good luck with your copywrite!

The source code request would be for a program code, appropriate if you actually wrote the code for the Excel program, but if you are copywriting a set of formulas or an excel execution sequence, then you want to print your formula view for copywriting.Excel has a Formula View that shows the formulas on your worksheet rather than the results of those formulas. You toggle between Formula View and Normal View by pressing CTRL ~ on your keyboard. Just toggle to formula view and print your worksheet to see all of your formulas.

Good luck with your copywrite!

Oct 06, 2008 | Microsoft Office Professional 2007 Full...

it sounds like you are going over the limits of the program these are the specs. I would recommend dividing up the data if you can. or moving it to a database that can act like excel and hold more data.

Apr 29, 2008 | Microsoft Excel for PC

If you mean that you can open the Workbook and read the Worksheet - then all you have to do is select all and paste it to another Worksheet. This will allow for changes of formulas etc.

If you mean the whole Workbook - then I dunno.

In future, either use the same password for everything (easy to remember) or Protect the work with nothing entered into the password field (leave this blank). This last will protect the work from people who try to guess your password, but will be easy for you to remember - eg every password is left blank.

If you must use unique passwords, then keep a record of them somewhere other than on your computer.

Sorry I can't help with the "Workbook" solution - but somebody else out ther may be able to do so.

If you mean the whole Workbook - then I dunno.

In future, either use the same password for everything (easy to remember) or Protect the work with nothing entered into the password field (leave this blank). This last will protect the work from people who try to guess your password, but will be easy for you to remember - eg every password is left blank.

If you must use unique passwords, then keep a record of them somewhere other than on your computer.

Sorry I can't help with the "Workbook" solution - but somebody else out ther may be able to do so.

Apr 25, 2008 | Microsoft Office Professional 2007 Full...

That depends on which version of Excel you are using.

Excel 2003 supports up to 65,335 formulas

Excel 2007 has no limit.

you can communicate between the worksheets which are contained by one workbook (one excel-file).

Communicating between files cannot be done with formula's.

Excel 2003 supports up to 65,335 formulas

Excel 2007 has no limit.

you can communicate between the worksheets which are contained by one workbook (one excel-file).

Communicating between files cannot be done with formula's.

Apr 04, 2008 | Microsoft Excel for PC

eg if i want to add to numbers

in sheet 1 i have the value 20 in cell B3

in sheet 2 i have the value 10 in cell B4

thus the formula would be:

=sheet1!B3+sheet2!B4

in sheet 1 i have the value 20 in cell B3

in sheet 2 i have the value 10 in cell B4

thus the formula would be:

=sheet1!B3+sheet2!B4

Mar 13, 2008 | Microsoft Excel for PC

You can add a reference from the worksheet 1 to all other worksheets

Is it OK?

Is it OK?

Mar 08, 2008 | Microsoft Excel for PC

You can refer to cells that are on other worksheets by perpending the name of the worksheet followed by an exclamation point (**!**)
to the cell reference. In the following example, the AVERAGE worksheet
function calculates the average value for the range C1:C10 on the
worksheet named Marketing in the same workbook.

Refers to the worksheet named Marketing Refers to the range of cells between C1 and C10, inclusively

Refers to the worksheet named Marketing Refers to the range of cells between C1 and C10, inclusively

- Click the cell in which you want to enter the formula.
- In the formula bar (formula
bar: A bar at the top of the Excel window that you use to enter or edit
values or formulas in cells or charts. Displays the constant value or
formula stored in the active cell.)
, type
**=**(equal sign). - Click the tab for the worksheet to be referenced.
- Select the cell or range of cells to be referenced.

Jan 01, 2008 | Microsoft Office Standard for PC

Dear jois you can make a link from one sheet to other sheet by making a hyperlink. When you will click one cell in first sheet it would shift the sheet in the cell you will fix it.

You can follow this process:

You can follow this process:

- Select a cell that contains the external formula
- Highlight the File path and sheet name in the Formula bar, eg; 'L:\Daves\[Book2.xls]Sheet1'!
- Push Ctrl+C then push Enter.
- Select the range of cells you wish to change the reference in and go to Edit>Replace.
- Select in the Find what box and hold down the Backspace to ensure you do not have a space.
- Push Ctrl+V.
- Do the same in the Replace with box and then edit the file path to the new one needed.
- Click Replace All

Nov 29, 2007 | Microsoft Excel for PC

Dear Madiha35,

I would recommend the use of the Table Function in Excel.

Here are the steps in Excel 2007, if this does not work for your version please add comment for me to reply to.

Conversely, If you would like the softcopy of the screenshots, I would be happy to email them to you.

Step 1: Enter your data into the worksheet.

Step 2: Create Table

Highlight the relevant data

On the insert tab, click on Table

Step 3: Verify Table range is correct, Click OK

Step 4: Select the cell you where you wish to Sum Data.

Click on Autosum.

Step 5: To Insert new data

Click on the sum row in the table, (Not the entire worksheet row)

Right click, Insert, Insert Table rows from above

Step 6: Enter new data in row

Step 7: Data is automatically calculated in formula.

Oct 22, 2007 | Business & Productivity Software

Oct 21, 2016 | The Business & Productivity Software

307 people viewed this question

Usually answered in minutes!

×