Need macro to drag values down to blank cells
- From: Greg Snidow <GregSnidow@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 5 Aug 2008 07:43:02 -0700
Greetings all. I have a spreadsheet that I use to upload data to a SQL
Server using bulk insert. Column 1 is for a town name, but it is only
populated for the first row of every town. For example, if there are 10 rows
of data for Leesburg, only row 1 would have "Leesburg" in column 1, and rows
2-10 will be blank for column 1, until you get to the next set of towns.
Lets say the next 10 rows are for Tampa, starting at row 11. Column 1 at row
11 will say "Tampa", but rows 12-20 will be blank, until the next town
starts. What I do is drag each town down through the section for that town,
so that every row has the town populated. Is there a way to do this
programatically?
Greg
.
- Follow-Ups:
- RE: Need macro to drag values down to blank cells
- From: dmoney
- RE: Need macro to drag values down to blank cells
- Prev by Date: RE: Closed File Still "Working"
- Next by Date: RE: How do I run code on startup before Excel re-calculates formulas?
- Previous by thread: macro to open file
- Next by thread: RE: Need macro to drag values down to blank cells
- Index(es):
Relevant Pages
|
