Autofill Sheet

[davidausten]

Every day I get a file from another department like the layout in Sheet 1. I need a way to auto populate Sheet 2 which has the names as headers horizontally instead of vertically. Currently I am doing this manually. I've tried using Index/Match without success so I was maybe looking for another formula way or a VBA solution. Was hoping to get suggestions as to how to proceed.

Ideally I would like to just open the daily file and have some way of auto populating Sheet 2 somehow. Thanks in advance for any suggestions, guidance or help.

Sheet 1:

Reporting Name Calls

9999 Sam 24
8888 John 10

Sheet 2:

Month Day Sam John

1 1 (calls go here)
1 2

 

[Logit]

.

Trying to follow your existing and proposed layout. Does the below represent what you are saying ?


[TABLE="class: head"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Sheet 1:[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Sheet 2:[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]

Reporting​

[/TD]
[TD]

Name​

[/TD]
[TD]

Calls​

[/TD]
[TD][/TD]
[TD]

Month​

[/TD]
[TD]

Day​

[/TD]
[TD]

Sam​

[/TD]
[TD]

John​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]

9999​

[/TD]
[TD]

Same​

[/TD]
[TD]

24​

[/TD]
[TD][/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[TD]

24​

[/TD]
[TD]

10​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]

8888​

[/TD]
[TD]

John​

[/TD]
[TD]

10​

[/TD]
[TD][/TD]
[TD]

1​

[/TD]
[TD]

2​

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Also, what does 9999 and 8888 represent ? How do those numbers compare to the MONTH / DAY fields on Sheet 2 ? That part is confusing.

 

[Peter_SSs]

Welcome to the MrExcel board!

Is the relevant date (or at least day and month) on Sheet 1 somewhere?
If not, how do we know what month and day to use on Sheet 2? Is it the current date that the code is run? .. the previous day's date? .. something else?