Data Entry & tabbed spreadsheet question
 

I have to make a change to some data being collected in preparation for
a web app that I am preparing to write.

I need to have a half-dozen users open up a spreadsheet and list
customer numbers & names, PO's and a user code to a single sheet inside
a workbook.

Then on each of 6 other tabs, I need to reproduce the same sheet, with
the exception being that sheet 2 needs to be for user 2 and sheet 3
needs to be for user 3. Either that, or I need to do it in reverse
order - where a user would update sheet 2,3 & 4 and sheet 1 is a
compiled list of those entries, one after the other.

The second option, of the two, would be the preferable, as that's
similar to how they do it now (with the exception of the "master" sheet
of all the orders).

Anyone know how to do this? (specifically the adding of a new record to
sheet one from the 6 other sheets in the workbook).

Thanks,

BC

Data Entry & tabbed spreadsheet question
 

=IF(Sheet1!A1<"",Sheet1!A1,"")
If you place this in A1 on your 'master sheet",
you can auto fill it .
Then when you need sheet2, change sheet1 to sheet2 for the cells that will
read from sheet2.
Try clicking on the cell after pasting this formula in in it, then
selecting the "fx" icon
that will enable you to try you own versions of formula to how thet suit you
best.

"Blasting Cap" wrote:

I have to make a change to some data being collected in preparation for
a web app that I am preparing to write.

I need to have a half-dozen users open up a spreadsheet and list
customer numbers & names, PO's and a user code to a single sheet inside
a workbook.

Then on each of 6 other tabs, I need to reproduce the same sheet, with
the exception being that sheet 2 needs to be for user 2 and sheet 3
needs to be for user 3. Either that, or I need to do it in reverse
order - where a user would update sheet 2,3 & 4 and sheet 1 is a
compiled list of those entries, one after the other.

The second option, of the two, would be the preferable, as that's
similar to how they do it now (with the exception of the "master" sheet
of all the orders).

Anyone know how to do this? (specifically the adding of a new record to
sheet one from the 6 other sheets in the workbook).

Thanks,

BC

Data Entry & tabbed spreadsheet question
 

If I'm doing it right, it always puts the record in A1 on the first
sheet it comes to in it.

What I'd wanted is to have:


Sheet2:A1 = "Sheet2"
Sheet3:A1 = "Sheet3"
Sheet7:A1 = "Sheet7"

Sheet1:A1 = Sheet2
Sheet1:A2 = Sheet3
Sheet1:A3 = Sheet7

and so on - where Sheet1 is essentially a row in a table. Sheets 4,5 &
6 cell A1 would all have nothing in them.

=IF(Sheet2!A2<"",Sheet2!A2,IF(Sheet3!A2<"",Sheet 3!A2,IF(Sheet4!A2<"",Sheet4!A2,IF(Sheet5!A2<"",S heet5!A2,IF(Sheet6!A2<"",Sheet6!A2,IF(Sheet7!A2< "",Sheet7!A2,""))))))

is how I changed the formula.


I'm not sure if this is the right tool for what I want to do. Any idea?

BC




ufo_pilot wrote:
=IF(Sheet1!A1<"",Sheet1!A1,"")
If you place this in A1 on your 'master sheet",
you can auto fill it .
Then when you need sheet2, change sheet1 to sheet2 for the cells that will
read from sheet2.
Try clicking on the cell after pasting this formula in in it, then
selecting the "fx" icon
that will enable you to try you own versions of formula to how thet suit you
best.

"Blasting Cap" wrote:

I have to make a change to some data being collected in preparation for
a web app that I am preparing to write.

I need to have a half-dozen users open up a spreadsheet and list
customer numbers & names, PO's and a user code to a single sheet inside
a workbook.

Then on each of 6 other tabs, I need to reproduce the same sheet, with
the exception being that sheet 2 needs to be for user 2 and sheet 3
needs to be for user 3. Either that, or I need to do it in reverse
order - where a user would update sheet 2,3 & 4 and sheet 1 is a
compiled list of those entries, one after the other.

The second option, of the two, would be the preferable, as that's
similar to how they do it now (with the exception of the "master" sheet
of all the orders).

Anyone know how to do this? (specifically the adding of a new record to
sheet one from the 6 other sheets in the workbook).

Thanks,

BC

Data Entry & tabbed spreadsheet question
 

you're a ****ing retard don't use Excel use a DATABASE

Lose the training wheels, kids

-Aaron


Blasting Cap wrote:
If I'm doing it right, it always puts the record in A1 on the first
sheet it comes to in it.

What I'd wanted is to have:


Sheet2:A1 = "Sheet2"
Sheet3:A1 = "Sheet3"
Sheet7:A1 = "Sheet7"

Sheet1:A1 = Sheet2
Sheet1:A2 = Sheet3
Sheet1:A3 = Sheet7

and so on - where Sheet1 is essentially a row in a table. Sheets 4,5 &
6 cell A1 would all have nothing in them.

=IF(Sheet2!A2<"",Sheet2!A2,IF(Sheet3!A2<"",Sheet 3!A2,IF(Sheet4!A2<"",Sheet4!A2,IF(Sheet5!A2<"",S heet5!A2,IF(Sheet6!A2<"",Sheet6!A2,IF(Sheet7!A2< "",Sheet7!A2,""))))))

is how I changed the formula.


I'm not sure if this is the right tool for what I want to do. Any idea?

BC




ufo_pilot wrote:
=IF(Sheet1!A1<"",Sheet1!A1,"")
If you place this in A1 on your 'master sheet",
you can auto fill it .
Then when you need sheet2, change sheet1 to sheet2 for the cells that will
read from sheet2.
Try clicking on the cell after pasting this formula in in it, then
selecting the "fx" icon
that will enable you to try you own versions of formula to how thet suit you
best.

"Blasting Cap" wrote:

I have to make a change to some data being collected in preparation for
a web app that I am preparing to write.

I need to have a half-dozen users open up a spreadsheet and list
customer numbers & names, PO's and a user code to a single sheet inside
a workbook.

Then on each of 6 other tabs, I need to reproduce the same sheet, with
the exception being that sheet 2 needs to be for user 2 and sheet 3
needs to be for user 3. Either that, or I need to do it in reverse
order - where a user would update sheet 2,3 & 4 and sheet 1 is a
compiled list of those entries, one after the other.

The second option, of the two, would be the preferable, as that's
similar to how they do it now (with the exception of the "master" sheet
of all the orders).

Anyone know how to do this? (specifically the adding of a new record to
sheet one from the 6 other sheets in the workbook).

Thanks,

BC