[mso] Re: Excel "insert"
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Sun, 23 Nov 2008 14:56:40 -0500
I'm not sure why my method won't work for you, Jim? I'm sure someone in
here who knows VBA could probably write you a macro to do this, but it's
really not that much work to do it manually.
You said: " what I'm looking for is a way to insert about 20 rows in one
shot every month or six weeks between my last daily entry, and my bottom
line totals"
So, highlight about 20 rows BELOW your last daily entry (they do not have to
be blank rows ... it doesn't matter if they have data in them) and go to the
Insert menu ONE time and choose to insert a row ... that will insert 20
blank rows below your last daily entry ... isn't that what you want? If
not, maybe someone else can help you more.
Linda
*********************************
Linda F. Johnson
Linda's Computer Stop
http://personal-computer-tutor.com
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of James Wells
Sent: Sunday, November 23, 2008 2:15 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Excel "insert"
Thanks for the input Linda, but I don't think I was totally clear regarding
my problem.
I'm doing daily moving averages on certain data consisting of a data base of
150 rows containing multiple columns. The number of rows remains constant.
Each day, I delete the top row (for me A-3 with it's 8 columns of data), and
add new(yesterday's) data in the 150th row. Therefore each day the rows
between my total and average line (my "bottom lines") get closer as one row
drops out. Eventually since my 150th row, and my total/average row have
almost met, I have to insert about 15 or 20 rows to continue my daily
process. I suppose I could insert a new row to my bottom line each day, but
that's a little cumbersome too.
what I'm looking for is a way to insert about 20 rows in one shot every
month or six weeks between my last daily entry, and my bottom line totals
and averages, without having to do it in 20 different "insert" entries.
Possibly there is no easy way to accomplish my hoped for short-cut, but I
thought I'd ask. I couldn't find an answer in Excel "Help" or in the big
"Office" Textbook I have, so maybe it's not possible..
Thanks,
Jim
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the dropdown
menu at the top. This will allow you to unsubscribe your email address or
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to share files with the group, you must join our Yahoo sister group.
This group will not allow for posting of emails, but will allow you to join
and share problem files, templates, etc.:
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE
SHARING ONLY.
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
Other related posts:
