 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / August 2006How can I set excel to automatically insert rows
I have a running worksheet to account for expenses and deposits. At the bottom of the sheet are the total values. I have to keep "inserting" rows to move the values further down the sheet. Tima I can be done, but..................... How will Excel know when you want to "automatically" insert a row or rows? You generally need some sort of trigger to fire an automatic response. Maybe a description of your layout and how you enter data will help. Gord Dibben MS Excel MVP >I have a running worksheet to account for expenses and deposits. At the >bottom of the sheet are the total values. I have to keep "inserting" rows to >move the values further down the sheet. Should read "It can be done" Gord >Tima > [quoted text clipped - 11 lines] >>bottom of the sheet are the total values. I have to keep "inserting" rows to >>move the values further down the sheet. Gord Dibben MS Excel MVP Some folks create the "Totals" row a 1,000 or so rows below the last data row. Then, they just insert an additional row right before or after the header row. They *link* this extra row to the "Totals" row to display the totals and *freeze* it together with the header row for a perpetual display of labels and amounts.  SignatureHTH, RD ===================================================== Please keep all correspondence within the Group, so all may benefit! ===================================================== I have a running worksheet to account for expenses and deposits. At the bottom of the sheet are the total values. I have to keep "inserting" rows to move the values further down the sheet. Thanks for the info so far. I am unable to figure out how to "link" the rows. > Some folks create the "Totals" row a 1,000 or so rows below the last data > row. [quoted text clipped - 7 lines] > to > move the values further down the sheet. Well!!! I did accomplish something better just now. I added rows between the last data entry row and the totals row like you suggested. Then I placed the totals row at the bottom of the page (view) and placed a split on the row above it. So now my worksheet will show the running data entries and the totals at the same time ans still update automatically. Sorry that I forgot to rate your reply. > Some folks create the "Totals" row a 1,000 or so rows below the last data > row. [quoted text clipped - 7 lines] > to > move the values further down the sheet. No rating necessary since I'm coming *directly* from the msnews.microsoft newsgroups. All the ratings here are the feed-back that we get from you.<g> As far as linking is concerned, after you insert a new, blank row above or below your headers, scroll down to your "Totals" row. Select the pertinent cells, say A1000 to E1000. Right click in the selection and choose "Copy". Navigate up to that new, blank row and right click in the Column A cell. Choose "Paste Special", then click on "Paste Link", then <Esc>, and you've linked your rows. All changes to the total row will *automatically* be displayed in that new 'pseudo' total row! SignatureRegards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- Well!!! I did accomplish something better just now. I added rows between the last data entry row and the totals row like you suggested. Then I placed the totals row at the bottom of the page (view) and placed a split on the row above it. So now my worksheet will show the running data entries and the totals at the same time ans still update automatically. Sorry that I forgot to rate your reply. "RagDyeR" wrote: > Some folks create the "Totals" row a 1,000 or so rows below the last data > row. [quoted text clipped - 7 lines] > to > move the values further down the sheet. I am happy you're happy, but none of this, in my opinion, is "automatically inserting rows" Gord >Well!!! I did accomplish something better just now. I added rows between the >last data entry row and the totals row like you suggested. Then I placed the [quoted text clipped - 14 lines] >> to >> move the values further down the sheet. Gord Dibben MS Excel MVP Sometimes Gord, you have to read between the lines.<bg> SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > I am happy you're happy, but none of this, in my opinion, is "automatically > inserting rows" [quoted text clipped - 21 lines] > > Gord Dibben MS Excel MVP Gotcha. After posting my whine I read over your exchange and realized I had taken the question too literally. Thanks for the slap upside the ear<g> >Sometimes Gord, you have to read between the lines.<bg> Gord Dibben MS Excel MVP |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.