LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default insert Rows with Formulas in Place on Multiple Sheets?

My fault, sorry. Think I missed this bit about
.. rows insert across all of the grouped sheets

earlier in your original post

(I had interp'd/read it wrongly that the row insertions
were going to be made on just Sheet1)

perhaps you might want to browse this response
to a similar query:

http://tinyurl.com/mt3pp

(the 2 "barebones" subs InsertRow and DeleteRow
seem to work ok for the OP over there, going by his reply <g)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Michael Link" wrote in message
...
Thanks again for the response. I must be pretty dense, though, because

when
rows insert across all of the grouped sheets, they continue to have no
formulas in them, and hence don't carry the stuff from the "master sheet"
forward. Your revision of the formula does carry info forward iin existing
rows, and that's great, but inserted rows on subsequent sheets are still
goiing in totally blank (with no formulas).

Hmm. I'm beginning to think it might just be easier to continue to be the
point person for all revisions to this thing. If I make it look mystical
enough they'll never fire me because no one else will know how to do it.

Job
seciurity.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
insert or delete rows across multiple worksheets? BobW Excel Discussion (Misc queries) 1 February 16th 06 05:02 PM
how do you add formulas on multiple excel sheets undercoverangeltn Excel Discussion (Misc queries) 1 February 13th 06 04:11 PM
Inserting Multiple Rows Mike Excel Discussion (Misc queries) 4 February 9th 06 01:21 AM
Insert Rows in Balance Sheet Template Teacher_Becky New Users to Excel 2 November 21st 05 02:15 AM
Copying multiple sheets from one book 2 another and undertake spec Pank Mehta Excel Discussion (Misc queries) 14 March 16th 05 04:41 PM


All times are GMT +1. The time now is 11:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"