Populate Cells with info contained in other cells

EC37 · #3 07-15-2014, 09:17 AM

lol. super fast response time to the private message I just sent you to enlist your help...

I had similar thoughts on how to write it- but of course was using only what I know (such as Copy & Paste). I didn't realize you save the value and then set the value to a new column. My other thought was what you had shown me previously on how to Group specific rows based on "Phase" and "Sub-Phase". Such as:

Code:

 
ez = Range("M1").End(xlDown).Row 
  Dim eStart, eEnd
  eEnd = 1
  Do
    eStart = StartRow1(eEnd, "Phase", ez)
    If eStart = 0 Then Exit Do
    eEnd = EndRow1(eStart, ez)
    Range(eStart & ":" & eEnd).Group
    Loop

But I didn't know how to edit it for my needs.

Yes, details would be helpful.

But no, it is not obvious as to why you are doing the second look backward- hoping you could explain.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can I pre-populate cells with a formula?	Box	Excel	1	05-03-2014 11:55 PM
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1	bobznkazoo	Excel	2	03-27-2014 11:14 AM
How-TO format cells (FILL) by comparing cells	zanat0s	Excel	1	07-03-2012 04:27 AM
Count range cells eliminating merge cells	danbenedek	Excel	0	06-15-2010 12:40 AM
Populate cells in Word from a database	hotlilshan	Word	3	12-09-2008 01:51 PM