365Runners
Welcome to 365Runners! We are here because we all share a running addiction. Whether training for a first marathon, a new PR, a new race distance, or anything else... welcome!

To stop the banner ads, please register and login. Otherwise, please enjoy browsing as a guest.

Join the forum, it's quick and easy

365Runners
Welcome to 365Runners! We are here because we all share a running addiction. Whether training for a first marathon, a new PR, a new race distance, or anything else... welcome!

To stop the banner ads, please register and login. Otherwise, please enjoy browsing as a guest.
365Runners
Would you like to react to this message? Create an account in a few clicks or log in to continue.

I need more rows!

+4
Admin
Alex Kubacki
Jerry
Dave-O
8 posters

Go down

I need more rows! Empty I need more rows!

Post  Dave-O Thu Aug 11, 2011 4:14 pm

Anyone here an expert with Excel? I need more rows added into my David Hayes running log. I can add rows, but it doesn't get all the equations for the other tabs.



Who would like to be 365runner MVP of the day and help a brutha out?
Dave-O
Dave-O
Moderator
Moderator

Posts : 1736
Points : 6358
Join date : 2011-06-14
Age : 41
Location : Chicago

http://www.fleetfeetchicago.com/

Back to top Go down

I need more rows! Empty Re: I need more rows!

Post  Jerry Thu Aug 11, 2011 4:19 pm

This is when you buy an Oracle database and hire Jerry to implement. lol!
Jerry
Jerry
Explaining To Spouse
Explaining To Spouse

Posts : 2712
Points : 1006096
Join date : 2011-06-15
Location : Where I'm Loved

Back to top Go down

I need more rows! Empty Re: I need more rows!

Post  Alex Kubacki Thu Aug 11, 2011 4:54 pm

Your best bet would be to insert rows prior to the last row and then copy the formulas down. This way it keeps the ranges that are in the formulas for the totals and everywhere else in place. First you'll need to unprotect the sheet and then you can show the Headings which are the columns and rows.



The password to unprotect is "dead".
Alex Kubacki
Alex Kubacki
Explaining To Spouse
Explaining To Spouse

Posts : 1252
Points : 5867
Join date : 2011-06-23

Back to top Go down

I need more rows! Empty Re: I need more rows!

Post  Admin Thu Aug 11, 2011 5:25 pm

Alex is right, but I used to just select a range of empty rows, copy, then insert/paste... that way the formulas copy as well.

Admin
Admin

Posts : 889
Points : 5734
Join date : 2011-06-14

Back to top Go down

I need more rows! Empty Re: I need more rows!

Post  KBFitz Thu Aug 11, 2011 6:02 pm

Highlight one or several full rows and copy them [by holding down on the mouse and scrolling in the row heading column (far left) then CTL-C or right click and select 'Copy']

Place your pointer on the last row heading column, right click and choose 'Insert Copied Cells'

This will insert those copied rows with equations right above the last row, moving the last row down and maintaining the integrity of any summary rows below.

Enjoy.
KBFitz
KBFitz
Explaining To Spouse
Explaining To Spouse

Posts : 1043
Points : 10369
Join date : 2011-06-15
Age : 64
Location : Off-center

Back to top Go down

I need more rows! Empty Re: I need more rows!

Post  Kenny B. Thu Aug 11, 2011 7:32 pm

dave I needed to do that last year and it worked but it would not carry over to the rest of the sheets. So if all you care about is the log page then just do as Kevin Suggested but don't expect data to transfer to other sheets at least that was my story. I assume because of all your double days you need more.
Kenny B.
Kenny B.
Explaining To Spouse
Explaining To Spouse

Posts : 2042
Points : 6710
Join date : 2011-06-15
Age : 50
Location : Jersey Shore!

http://www.365Competitors.com

Back to top Go down

I need more rows! Empty Re: I need more rows!

Post  Dave-O Fri Aug 12, 2011 9:34 am

Thanks all. Joel took care of me...again...for like the 3rd year.


Whenever I try it, the weekly and monthly totals get all jacked up.
Dave-O
Dave-O
Moderator
Moderator

Posts : 1736
Points : 6358
Join date : 2011-06-14
Age : 41
Location : Chicago

http://www.fleetfeetchicago.com/

Back to top Go down

I need more rows! Empty Re: I need more rows!

Post  Joel H Fri Aug 12, 2011 10:31 am

Dave-O wrote:Thanks all. Joel took care of me...again...for like the 3rd year.


Whenever I try it, the weekly and monthly totals get all jacked up.



I told you I would do it man...sorry it took me a few days to get it to you but I do have to pay the bills first. Laughing
Joel H
Joel H
Regular
Regular

Posts : 539
Points : 4787
Join date : 2011-06-27
Age : 44
Location : The Hottest Part of the Sun!

Back to top Go down

I need more rows! Empty Re: I need more rows!

Post  Jerry Fri Aug 12, 2011 10:43 am

Joel H wrote:
Dave-O wrote:Thanks all. Joel took care of me...again...for like the 3rd year.


Whenever I try it, the weekly and monthly totals get all jacked up.



I told you I would do it man...sorry it took me a few days to get it to you but I do have to pay the bills first. Laughing

Looks more like Joel planted a time bug there. Shots
Jerry
Jerry
Explaining To Spouse
Explaining To Spouse

Posts : 2712
Points : 1006096
Join date : 2011-06-15
Location : Where I'm Loved

Back to top Go down

I need more rows! Empty Re: I need more rows!

Post  Dave-O Fri Aug 12, 2011 10:52 am

Joel H wrote:
I told you I would do it man...sorry it took me a few days to get it to you but I do have to pay the bills first. Laughing

I thought maybe I had an out of date email address. Or that I was just annoying you. Approval
Dave-O
Dave-O
Moderator
Moderator

Posts : 1736
Points : 6358
Join date : 2011-06-14
Age : 41
Location : Chicago

http://www.fleetfeetchicago.com/

Back to top Go down

I need more rows! Empty Re: I need more rows!

Post  Joel H Fri Aug 12, 2011 11:01 am

Jerry wrote:
Joel H wrote:
Dave-O wrote:Thanks all. Joel took care of me...again...for like the 3rd year.


Whenever I try it, the weekly and monthly totals get all jacked up.



I told you I would do it man...sorry it took me a few days to get it to you but I do have to pay the bills first. Laughing

Looks more like Joel planted a time bug there. I need more rows! 1193849567



Since I am doing it for FREE, why would I want to force myself to do more work, now that is just dumb! scratch
Joel H
Joel H
Regular
Regular

Posts : 539
Points : 4787
Join date : 2011-06-27
Age : 44
Location : The Hottest Part of the Sun!

Back to top Go down

I need more rows! Empty Re: I need more rows!

Post  Joel H Fri Aug 12, 2011 11:02 am

Dave-O wrote:
Joel H wrote:
I told you I would do it man...sorry it took me a few days to get it to you but I do have to pay the bills first. Laughing

I thought maybe I had an out of date email address. Or that I was just annoying you. I need more rows! 424776184



Nope, neither of those...just busy! Again sorry for the delay in response.
Joel H
Joel H
Regular
Regular

Posts : 539
Points : 4787
Join date : 2011-06-27
Age : 44
Location : The Hottest Part of the Sun!

Back to top Go down

I need more rows! Empty Re: I need more rows!

Post  Michele "1L" Keane Sun Aug 14, 2011 8:31 am

This reminded me to send the actual executable file to Joel to see if he can add the rows (to the shoe area for Dave and I) permanently!!!!
Michele
Michele "1L" Keane
Needs A Life
Needs A Life

Posts : 5025
Points : 13764
Join date : 2011-06-15
Age : 61
Location : Atlanta, GA

http://1lranthere.blogspot.com

Back to top Go down

I need more rows! Empty Re: I need more rows!

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum