Read List of Names from different sheet

[tonyj32]

What I am wanting to to do is use Excel to enter time sheets that repeat but change names.

Here is what I mean.

Employee
Location 1
Location 2
Location 3
Location 4

This is repeated approx 300 times, once for each employee.
The problem is every time someone is hired or fired. we have to go in and cut the entire block or insert a block.

I was wondering if I could just take a list from another sheet that I can sort and have excel read those names and put the names
in the blocks automatically.

Then I could just add a block at the end and Excel will read the sorted list and put the names in the block automatically.


Thanks

[FDibbins]

Hi and welcome to the forum

Im sure we can come up with something for you, do you have a sample to show us what you are working with - and what you want?

[tonyj32]

Example.xls

This is what we have, except repeated about 300 times..

If there was a way I could replace the first and last name from
a sorted list on another sheet or workbook, I could just copy and
insert a same sized block at the end and add a name to my list, then sort it.

This actually part of a larger workbook that has three sheet, one for first week in
pay period, then one for the second week, then one for combining those two sheets.


Thanks,

Tony

[FDibbins]

I see what you are working with, but still not sure what you want?

To get the names, you could use Data Validation to give you a list of all names, and then you could use vloolup() or index/match() to pull in specific data. But I would need to see more sample data (and a few sample answers) before I can be more specific

[tonyj32]

Sorry, I am wanting to replace the Highlighted "First Name, Last Name" Sequentially from a list of names.

Example,

If I maintain a worksheet with a plain list of names

Anderson, John
Bell, Vernon
Christy, Matt
ETC....

I would like to be able to just replicate the blocks in the sheet I sent earlier,
then have Excel pick the next name from the list...

Sorry, I am clear as mud today,,,

Need more sleep!!!

Thanks,

Tony

[tonyj32]

Let me see if I can ask this in a shorter more concise way.

Let's say a have in cell A1 =Sheet2!A1

I want to copy and paste a block of cells "A1:L20" And start them at A25 to but I want A25 to read =Sheet2!A2

Is there a formula I can use that will read the Cell address and see that I went down 24 rows and convert what would have read =Sheet2!A25 but convert it to
=Sheet!A2 using something like (A25-1)/12 = 2