I have a workbook with several sheets attached to it.
All my sheets perform as I want except 1.
I have a data sheet that has several data entry fields with different dates and amount of players.
i need to get this info into a 2nd sheet without doing a copy and paste.
I need to transfer the Week, Players, P, HH, and F/F fields into sheet 4:
Week March 13, 2015
# Players 21
Name January 29, 2016
13
Pld P HH F/F
x
x 4 $25
x 2 $15
x 3 $20
x 5 $40
x 7 $90
x $16
x
x 6 $50 $26
x
x 1
x
x
My problem is that WEEK and PLAYERS change week to week. I'm tired of "Copy and Paste". I need the first sheet for other calculations.
Can anyone suggest a way to do this?
Thanks in advance.
Bookmarks