Jump to content
  • 0
Sign in to follow this  
Followers 0

Excel questions

Question

Posted

First problem.
I'm trying to PUSH data to a cell from multiple locations. Let's say I have cell A1.
The default value of A1 is 0. I'd like to have other cells push their values to A1, so like I could set B1 to be
add +1 and C1 to be add +1 to A1, and now A1 shows up as 2. Is this possible?

Share this post


Link to post
Share on other sites

13 answers to this question

  • 0

Posted

I'm guessing there is a reason you can't simply just set cell A1 like:
[CODE]
=SUM(B1,C1)
[/CODE]
? As it will automatically readd if values are changed (if you haven't disabled that)

To actually PUSH data, I think you'll need a VB script or such.

Share this post


Link to post
Share on other sites
  • 0

Posted

The reason is this:
If I have A1 go out and look for those cells (B1 and C1 in this example) then I need to keep track of all those Cells.
However, if I can have Cells push their data to A1, I can add or remove them at my leisure without having to
adjust the formula for A1 every time. Having to continue adding the formula string in A1 gets confusing, long,
and heaven forbid I move those cells around.

With a push method, it's a one-step process: Add new cell, have it send data to A1.
With a pull method, I add a new cell and THEN have to go back to A1 and change it as well.

Share this post


Link to post
Share on other sites
  • 0

Posted

Could you not just name a range, then when you add new cells make sure they lie within that range? Should be able to use simple equations then and not alter A1 every time.

Share this post


Link to post
Share on other sites
  • 0

Posted

What if you use another worksheet and in cell A1, sum the entire second worksheet?

Share this post


Link to post
Share on other sites
  • 0

Posted

No. The cells that would add values to A1 are scattered, some in different worksheets. I can't pull them out of their location
and put them together... it's just the nature of the data.

Share this post


Link to post
Share on other sites
  • 0

Posted

Excel's formula's are designed as pull. Either you have to re-look at how you organizing you data or update the formula for A1 accordingly.

Share this post


Link to post
Share on other sites
  • 0

Posted

Fixed

Share this post


Link to post
Share on other sites
  • 0

Posted

New Issue.

I have cells D6 -D11 formatted to use a drop-down list.
The options are: C, S, F. The F option is default in every cell.
Only one cell can choose an option of C or S, but they can all have F.
I need to be able to forbid someone from selecting C or S if C or S appears
in any other cell. Thanks!

Share this post


Link to post
Share on other sites
  • 0

Posted

more than likely gonna have to use vba for this

So do something like

on cell change

if range (blah:blah) has "C" then msgbox "error C already exists"

Share this post


Link to post
Share on other sites
  • 0

Posted

I'm trying not to use any scripts.
How about a Conditional Formatting formula so I can make the cells red
if C or S appear in more then one cell?

Just to be clear, all cells begin with F... so multiple F is ok.
If any cell contains a C or an S then every other cell must contain F.

Share this post


Link to post
Share on other sites
  • 0

Posted

yeah suppose you could have something like

if(OR(D6="C",D6="S",D7="C",D7="S",D8="C",D8="S",D9="C",D9="S",D10="C",D10="S",D11="C",D11="S"),,)

Share this post


Link to post
Share on other sites
  • 0

Posted

are you using the newest office?

if so in confitional formatting there is a Duplicate bit

Share this post


Link to post
Share on other sites
  • 0

Posted

Yea, I tried the Duplicate function... however, there are duplicates by default: F
Thus, it doesn't work.

The formula you posted didn't work, either.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.