If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
looking for a function that will populate opening a worksheet or t
I need some help to see if Excel will be able to accommodate a task I would
like to do. I have this tax payment worksheet in excel, what I would like to happen is the following: if I enter data (dollar amount that is not equal to zero) in a certain column, then excel would automatically populate or open an existing worksheet or take me to another tab in the same worksheet, so that I am reminded to fill out the same dollar amount in other spreadsheet. |
#2
|
|||
|
|||
looking for a function that will populate opening a worksheet or t
EXCEL 2007
Try this:- 1. In Sheet1 cell A1 I enter, for example:- hello The above can be anything you like. 2. In Sheet2 cell a1 (or any cell of your choice) I type:- =Sheet1!A1 This pulls in the word:- hello - from Sheet1 cell A1. Adapt the above to your needs. If my comments have helped please hit Yes. Thanks. "Olivia" wrote: I need some help to see if Excel will be able to accommodate a task I would like to do. I have this tax payment worksheet in excel, what I would like to happen is the following: if I enter data (dollar amount that is not equal to zero) in a certain column, then excel would automatically populate or open an existing worksheet or take me to another tab in the same worksheet, so that I am reminded to fill out the same dollar amount in other spreadsheet. |
#3
|
|||
|
|||
looking for a function that will populate opening a worksheet
I don't think will solve the problem, I use excel's functions and formulas
all the time, but I am looking for something more advanced. There is not always an dollar amount to entered into the cell. I did try using the Data Validation, which gives me a warning or a pop up box. I thinking I may need a macro of some sort. Thanks "trip_to_tokyo" wrote: EXCEL 2007 Try this:- 1. In Sheet1 cell A1 I enter, for example:- hello The above can be anything you like. 2. In Sheet2 cell a1 (or any cell of your choice) I type:- =Sheet1!A1 This pulls in the word:- hello - from Sheet1 cell A1. Adapt the above to your needs. If my comments have helped please hit Yes. Thanks. "Olivia" wrote: I need some help to see if Excel will be able to accommodate a task I would like to do. I have this tax payment worksheet in excel, what I would like to happen is the following: if I enter data (dollar amount that is not equal to zero) in a certain column, then excel would automatically populate or open an existing worksheet or take me to another tab in the same worksheet, so that I am reminded to fill out the same dollar amount in other spreadsheet. |
Thread Tools | |
Display Modes | |
|
|