Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I used to be able to do this, I can't remember how
Hi, I have a sheet that is giving me some issues. It is a simple pivot that has store # in column A and vendor name is column B. Ther are upwards of 20 vendors for each store. When I run the pivot it puts the store # in the first cell of the pivot and lists the vendors in the next column. However, after the first column the store number is blank until it gets to the next store. I am converting the pivot to values after I run it. What I'm trying to do is find a formula that will fill the store # for all the blanks until it gets to the next store. I want it to fill in all blanks with the store # above the blanks until it gets to the next store. Does anyone know how to do this? Thanks Eddie. -- punter ------------------------------------------------------------------------ punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044 View this thread: http://www.excelforum.com/showthread...hreadid=518071 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I used to be able to do this, I can't remember how
Try Debra Dalgleish's page for some nice ideas on filling in the blank
cells: http://www.contextures.com/xlDataEntry02.html Fill Blank Cells Fill Blank Cells Programmatically -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "punter" wrote in message ... Hi, I have a sheet that is giving me some issues. It is a simple pivot that has store # in column A and vendor name is column B. Ther are upwards of 20 vendors for each store. When I run the pivot it puts the store # in the first cell of the pivot and lists the vendors in the next column. However, after the first column the store number is blank until it gets to the next store. I am converting the pivot to values after I run it. What I'm trying to do is find a formula that will fill the store # for all the blanks until it gets to the next store. I want it to fill in all blanks with the store # above the blanks until it gets to the next store. Does anyone know how to do this? Thanks Eddie. -- punter ------------------------------------------------------------------------ punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044 View this thread: http://www.excelforum.com/showthread...hreadid=518071 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I used to be able to do this, I can't remember how
Thank you so very much. As always the kind and smart people on this board had the solution to the issue. Eddie -- punter ------------------------------------------------------------------------ punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044 View this thread: http://www.excelforum.com/showthread...hreadid=518071 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
I used to be able to do this, I can't remember how
You're welcome, Eddie !
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "punter" wrote in message ... Thank you so very much. As always the kind and smart people on this board had the solution to the issue. Eddie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel does not remember printer settings | Setting up and Configuration of Excel | |||
can't remember password | Excel Worksheet Functions | |||
can't remember password | Excel Worksheet Functions | |||
I downloaded excel and don't remember password how do I get | Excel Discussion (Misc queries) | |||
How do I get a cell to remember the last entry and add to it? | Excel Discussion (Misc queries) |