simple spreadheet

[waylander32]

Hi
trying to design a very simple spreadsheet that calculates wages.
the problem I'm having is this

I have one sheet that has all the personnel detail 1 line per person (data)

I have another sheet that has all the times. on this sheet one person has 4 rows (input)

The key details are referenced in the input sheet form the data sheet is there a way of dragging the formula down

the only way I can describe it is 4 cells down on the input sheet = 1 cell down on the data sheet


as I need to design the sheet to handle about 50 to 100 employees If someone know how to do this I would be very gratefull


sorry if not made my self clear

 

[Brianwarnock]

Are you saying that you have Cells on the data sheet that are referenced by formula on the input sheet and that you only want to code this once and drag it down over 3 more rows, if so use absolute addressing

=Sheets("data")!$A$1

Brian

 

[NBVC]

Brian, I think the syntax would be:

=data!$A$1

but somehow, I don't think that is what the OP is wanting. Can you please post a sample workbook showing what you need?

 

[Brianwarnock]

NBVC you are correct, I had just been writing code and was still in VBA mode

Brian