How to Auto Populate Entire Row With Previous Values Already Entered by Entering Name on First Column?

[Kevincolby650]

Hello, I do alot of repetitive work and looking for away to auto fill a row with the last entries I entered based off of a name in the Second column. Every day I need to enter in the same values, but sometimes one value changes and stays for awhile. So I would like to populate from the last values I entered. I have tried the following formula, but when the workbook gets big it is very slow to process each value i enter, and sometimes very slow to respond.

=IFERROR(INDIRECT(ADDRESS( SUMPRODUCT(MAX(--($B4=$B$3:$B3)*(ROW($3:3)))),COLUMN())),"")

If anyone knows a better way to do this or a formula that would work better I would greatly appreciate it.
Here is a pic of what im looking for.

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff New.xlsm
	A	B	C	D	E	F	G
1
2
3		Kevin	1	1	1	1	1
4		Kevin	2	1	1	1	1
5		John	1	2	2	2	2
6		Kevin	2	1	1	1	1
7
8
9
10
Main

Cell Formulas
Range	Formula
C6:G9	C6	=IF($B6="","",LOOKUP(2,1/($B$3:$B5=$B6),C$3:C5))

 

[Kevincolby650]

I tried this out in a sample book and it seems so much faster and does what I wanted. I spent a few days trying to figure that out. Thank you SO MUCH!

 

[Fluff]

You're welcome & thanks for the feedback.