Retrieving Data Using Excel

[ChompGator]

Hey,

I have a `master` listing that has a list of material on it.
Lets call it test.xls

Each employee has their own work work-book with only one sheet inside the work book, lets call this test1.xls

I want users to be able to add information in test1.xls and the list test.xls automatically gets updated

What kind of formula do I use for this?

- Jeff

 

[angiemeh]

If #1 starts in Cell A6, you only want to put the formula where # 2 will be. The formula will not be put anywhere else.

Therefore, you would put the formula in cell A7. The formula would be

=if(b7="","",a6+1)

So if there is no data in B then there will be a blank. A blank in Excel is "" with nothing between the two quotes. Then if there is something in B, it takes the previous cell + 1.
That is how you are doing the auto-renumber.

Cell A7 is 1 and then A2 says, if there is data in B2 then add 1+1 = 2. Eventually when you do all the steps below, this is how you are going to renumber the cells using a macro.

If a user adds a row and they put data in B, then this formula will work. If data does not exist in B- the macro will stop at the row the user added.

 

[ChompGator]

I see excatly what your saying now (it works now)
=if(b7="","",a6+1)

Is saying = in a6 + (add 1) for a7 and that makes the number go up in the increment of 1...That is brilliant lol...thanks - Im going to continue with the directions you posted, and Ill try and post here again today, otherwise it wont be until Monday - I just had something come across my desk that needs immediate attention, so if I finish it quick Ill post here again today, if I dont post here again today - Ill post on Monday!

Thanks!