Solved

filling in data until data breaks

Posted on 2013-01-29
2
177 Views
Last Modified: 2013-01-29
Please see the attached document.  I am hoping to come up with a more automated way of filling in data gaps in a spreadsheet.  It's an abbreviated version of a much large spreadsheet, but I drew some arrows in there explaining what i would like to be able to do.
Basically column A has heading data but when the heading data is the same for the next row of data the headings drop of the subsequent rows, but I need it to fill in. Currently I am going through and copying the cell contents down until i get to the next data set, but I am not sure I will live long enough to do it this way. LOL

Thanks
Book1.xlsx
0
Comment
Question by:wcody
  • 2
2 Comments
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 500 total points
ID: 38831994
Without a macro

Select the column A range
press F5
Click on special
Select blanks
Click OK
type   =
from the keyboard move the cursor one cell up
press ctrl-enter
0
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 38832009
Here is a macro if you wish

Sub fillwithuppercells()
ActiveSheet.UsedRange.Columns(1).SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=r[-1]c"
End Sub
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Resolve Outlook connectivity issues after moving mailbox to new Exchange 2016 server
Following basic email etiquette rules will help you write a professional email and achieve a good, lasting impression with your contacts.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now