Re: Does this have to be done manually?

From: Dave Peterson <petersod@xxxxxxxxxxxxxxxx>
Date: Thu, 22 Sep 2005 13:17:31 -0500

Debra Dalgleish has some techniques at:
http://contextures.com/xlDataEntry02.html

Dorn wrote:
>
> When I get my data it comes in this format:
>
> Company Name
> Data Data
> Data Data
> A Different Company Name
> Data Data
> Data Data
> Data Data
> Data Data
> Another Different Company
> Data Data
> Data Data
>
> How can I fill down the company names into the empty cells on the same row
> as the data, I know how to fill down one section at a time but how do I do it
> automatically for all of them?

--

Dave Peterson
.

Prev by Date: Re: Pivot Table - Sub totals
Next by Date: Re: Match result is sometimes #N/A
Previous by thread: Re: Pivot Table - Sub totals
Next by thread: Re: Match result is sometimes #N/A
Index(es):
- Date
- Thread

Relevant Pages

Re: pivot table "sum of "-field is not working
... Even though the field is formatted as numbers, Excel is probably seeing the dates in the source table as text. ... There are some techniques here that you can use to convert the text to dates, so they can be summed correctly: ... The field is formatted to number format. ... Debra Dalgleish ...
(microsoft.public.excel.misc)
Re: Excel PivotTable sort of dates
... Kelcom wrote: ... Last night I kept trying to get into my ebook: "Excel Pivot Tables Recipe Book - A Problem-Solution Approach" written by Debra Dalgleish herself. ... So, I created a formula cell that said that if one date was greater than the other, then use the greatest on, if not use the other. ... Select one of the dates, and choose Format>Cells, and select a different date format. ...
(microsoft.public.excel.misc)
Re: Excel PivotTable sort of dates
... Debra Dalgleish herself. ... determine if a cell contains text or numbers. ... For Column Data Format, select Date, and in the dropdown, select the ... tried to rerun the pivot tables. ...
(microsoft.public.excel.misc)
Re: ive seen this before here yet the macro is hard to search
... to format the coments, see Debra Dalgleish ... Format All Comments ... To keep an historic snapshot record of the ... I need to compile these comments regularly, since i need to revise them ...
(microsoft.public.excel.programming)
Re: Format Drill to Details Table
... "Debra Dalgleish" wrote: ... > GillianHG wrote: ... >> not format after the fact. ... >> and the executives double-click their department to see their detail data. ...
(microsoft.public.excel.misc)