 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2007Fill in Blank rows with data from above
OK - So I have text in A1 Then column A is blank down to A(x) (x being and possible number. Then I have different text in the next row in A. A(x+1). This happens repeatedly through out about 50,000 records (that rules out using the auto fill) How can I populate ALL the blank rows in column A with the text that is above it? I know it is doable - but I just can't remember the procedure. Any help here will be appreciated. Thanks in advance dave There are instructions here to fill the blank cells manually or programmatically: http://www.contextures.com/xlDataEntry02.html > OK - So I have text in A1 > Then column A is blank down to A(x) (x being and possible number. [quoted text clipped - 5 lines] > I know it is doable - but I just can't remember the procedure. > Any help here will be appreciated.  SignatureDebra Dalgleish Contextures http://www.contextures.com/tiptech.html Are you available to answer a worksheet consolidation question no one else will answer? > There are instructions here to fill the blank cells manually or > programmatically: I'll take a look at it. Where is the question posted? > Are you available to answer a worksheet consolidation question no one else > will answer? > >>There are instructions here to fill the blank cells manually or >>programmatically: SignatureDebra Dalgleish Contextures http://www.contextures.com/tiptech.html Here is my question: I'm consolidating 3 worksheets into one by using Excel 2007 data consolidation. The worksheets have product numbers in column A and sales figures in columns B, C & D for Jan, Feb and Mar which are column labels. The worksheets are in product number sequence. Not all product numbers appear on each sheet, so I consolidate by category using "labels in left column", "labels in top row" and "create links to source data" to create a consolidation sheet in outline form. The problem is the consolidated worksheet is not in product number sequence as I need it to be. When I consolidate to a regular (non outline) sheet, the consolidated sheet is out of sequence too. I have books on Excel 2007 and Excel 2003 and their consolidated worksheet examples are not in sequence either although their input sheets are. Any ideas? Thanks. Tyro > I'll take a look at it. Where is the question posted? > >> Are you available to answer a worksheet consolidation question no one >> else will answer? After you consolidate the data, you should be able to sort the labels. They'll appear out of order if you update, so repeat the sort to put them back in order. > Here is my question: > [quoted text clipped - 23 lines] >>>Are you available to answer a worksheet consolidation question no one >>>else will answer? SignatureDebra Dalgleish Contextures http://www.contextures.com/tiptech.html I cannot sort the labels (product numbers) in a consolidated worksheet in outline form. The product numbers are in column A and the supporting detail items do not have part numbers in column A. They have blanks. They have the sheet name in column B. The fact that the sheets are out of sequence defeats the whole purpose of consolidation. Microsoft must know this. Tyro > After you consolidate the data, you should be able to sort the labels. > They'll appear out of order if you update, so repeat the sort to put them [quoted text clipped - 30 lines] >>>>Are you available to answer a worksheet consolidation question no one >>>>else will answer? I meant product numbers, not part numbers. Sorry. > I cannot sort the labels (product numbers) in a consolidated worksheet in > outline form. The product numbers are in column A and the supporting [quoted text clipped - 40 lines] >>>>>Are you available to answer a worksheet consolidation question no one >>>>>else will answer? A useful feature of the Consolidate command is that if you select a range instead of a single cell before choosing Data > Consolidate, any existing Row or Column headings in that range will be used. So maybe if you do not already have a list of product numbers try doing this in two steps: 1. Select a cell then Data > Consolidate without creating links to get a list of product numbers 2. Sort by first column, and with the whole range selected choose Data > Consolidate again with the Create Links option checked Use "Count" as the summary function to include text values in the output. > I cannot sort the labels (product numbers) in a consolidated worksheet in > outline form. The product numbers are in column A and the supporting detail [quoted text clipped - 38 lines] > >>>>Are you available to answer a worksheet consolidation question no one > >>>>else will answer? I selected row and column headings. They are there in the output sheet. But the output sheet is out of sequence by product number. The input sheets are in sequence by product number.. >A useful feature of the Consolidate command is that if you select a range > instead of a single cell before choosing Data > Consolidate, any existing [quoted text clipped - 9 lines] > > Use "Count" as the summary function to include text values in the output. Thanks - that was exactly what I needed. dave > There are instructions here to fill the blank cells manually or > programmatically: [quoted text clipped - 10 lines] >> I know it is doable - but I just can't remember the procedure. >> Any help here will be appreciated.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.