Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
insert rows
I'm using Excel 2000.
The problem: 1. Multiple widget references (i.e. cell contains "R1-R3, R5") are in one row with various information in other columns. My goal: 1. I want to insert X amount of rows (insert 3 in this case) with identical information (except for the widget references). 2. Then change the widget references to include one reference per row (i.e. 1st row = R1, 2nd = R2, 3rd = R3, 4th = R5) I'm not a savvy programmer. Can anyone help me out? Thanks, Scott |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
insert rows
Scott,
Your request is unintelligable. For $92.00 per hour I can make Excel do wot ever you desire. Jill -----Original Message----- I'm using Excel 2000. The problem: 1. Multiple widget references (i.e. cell contains "R1- R3, R5") are in one row with various information in other columns. My goal: 1. I want to insert X amount of rows (insert 3 in this case) with identical information (except for the widget references). 2. Then change the widget references to include one reference per row (i.e. 1st row = R1, 2nd = R2, 3rd = R3, 4th = R5) I'm not a savvy programmer. Can anyone help me out? Thanks, Scott . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
insert rows
Hi Scott, (posted with courtesy email copy)
You question might more sense if you used some actual cell references instead of ambiguous references that happen to look like cell references. But as Jill indicated succinctly "Your request is unintelligible". Part of being a programmer is the ability to define and solve a problem. I would suggest looking at Insert a Row using a Macro to maintain formulas http://www.mvps.org/dmcritchie/excel/insrtrow.htm Along with looking at macro solutions you should know how to insert rows manually, and how to use the fill-handle. Including using the Ctrl key with the fill-handle. May or may not help you with the macro but it will sure make you appreciate a macro solution. You will get the best use out of newsgroups if you take the time to ask a question that does not need to be further explained. You will get an example of what I mean In my comments on the above page, to how I got help with what I wanted. Please keep conversation in newsgroup. Email copy was included because there are or have been some problems with newsgroups lately. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Scott Miller" wrote in message ... I'm using Excel 2000. The problem: 1. Multiple widget references (i.e. cell contains "R1-R3, R5") are in one row with various information in other columns. My goal: 1. I want to insert X amount of rows (insert 3 in this case) with identical information (except for the widget references). 2. Then change the widget references to include one reference per row (i.e. 1st row = R1, 2nd = R2, 3rd = R3, 4th = R5) I'm not a savvy programmer. Can anyone help me out? Thanks, Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert rows in a worksheet that do not change adjoining rows | Excel Discussion (Misc queries) | |||
How do i insert blank rows between data that is thousands of rows | Excel Discussion (Misc queries) | |||
Insert rows: Formats & formulas extended to additonal rows | Excel Worksheet Functions | |||
How do I insert blank rows between rows in completed worksheet? | Excel Discussion (Misc queries) | |||
How do i insert of spacer rows between rows in large spreadsheets | Excel Discussion (Misc queries) |