PDA

View Full Version : google spreadsheet help



venusrena
04-27-2013, 11:23 AM
I have a workbook with 12 worksheets one for each month
Jan,Feb,March,April,May,June,July,Aug,Sep,Oct,Nov,Dec
Each sheet has 20 rows one row for each player
Col Names are:

rank - A
Players - B
C-J - (Dates)
(last month) points - K
(this month) points- L
Total points - M
played - N
% - O
AVERAGE - p
1st places - R
2nd places - S
3th place- T

What i need to do is pull each players row from all the sheets and
put them in a sheet of their own Players start in row 2 on each
sheet and their are 20 rows so i would need row 2 of each sheet
pulled into another sheet and then row 3 from each sheet pulled
into it's own sheet and so on for each row But i only need the cols
with these heading names added to the new sheet
Heading names are in row one on each sheet

Players
Points
played
%
averages
1st places
2nd places
3th places

is there a code that i can use in a google spreadsheet that will
do this for me and update each time data is added to the monthly
sheets?:dunno