Posts by bthayer

    Excel 2010 pulled external data from a Sage 100 inventory file. I have a pivot table with these items, Data is Product Line, Product Code, Pack, Sales


    Data looks like this in the report with first 3 fields in the row box and Sales in the Value box. Report has these items going down the page under each other in Column A


    Product Line
    Product Code
    Pack
    Sales
    All showing Column A


    I want the data to look like this


    Product Line Column A, Product code Column B, Pack Column C, Sales Column D


    How do I get them to go across the page and not up and down? I have a thousand item so moving them to the Column box does not work. Bob

    Excel 2010 pulled external data from a Sage 100 inventory file. I have a pivot table with these items, Data is Product Line, Product Code, Pack, Sales


    Data looks like this in the report with first 3 fields in the row box and Sales in the Value box. Report has these items going down the page under each other in Column A


    Product Line
    Product Code
    Pack
    Sales
    All showing Column A


    I want the data to look like this


    Product Line Column A, Product code Column B, Pack Column C, Sales Column D


    How do I get them to go across the page and not up and down? I have a thousand item so moving them to the Column box does not work. Bob

    Excel 2010 pulled external data from a Sage 100 inventory file. I have a pivot table with these items, Data is Product Line, Product Code, Pack, Sales


    Data looks like this in the report with first 3 fields in the row box and Sales in the Value box. Report has these items going down the page under each other in Column A


    Product Line
    Product Code
    Pack
    Sales
    All showing Column A


    I want the data to look like this


    Product Line Column A, Product code Column B, Pack Column C, Sales Column D


    How do I get them to go across the page and not up and down? I have a thousand item so moving the to the Column box does not work. Bob

    Excel 2010 pulled external data from a Sage 100 inventory file. I have a pivot table with these items, Data is Product Line, Product Code, Pack, Sales


    Data looks like this in the report with first 3 fields in the row box and Sales in the Value box. Report has these items going down the page under each other in Column A


    Product Line
    Product Code
    Pack
    Sales
    All showing Column A


    I want the data to look like this


    Product Line Column A, Product code Column B, Pack Column C, Sales Column D


    How do I get them to go across the page and not up and down? I have a thousand item so moving the to the Column box does not work. Bob

    Excel 2010 pulled external data from a Sage 100 inventory file. I have a pivot table with these items, Data is Product Line, Product Code, Pack, Sales


    Data looks like this in the report with first 3 fields in the row box and Sales in the Value box. Report has these items going down the page under each other in Column A


    Product Line
    Product Code
    Pack
    Sales
    All showing Column A


    I want the data to look like this


    Product Line Column A, Product code Column B, Pack Column C, Sales Column D


    How do I get them to go across the page and not up and down? I have a thousand item so moving the to the Column box does not work. Bob

    Re: Passing Variables Between Subs


    SHG Thank you so much. That worked great. Help me to understand the statment for future.

    Code
    1. Call ReStoreOrder(OldOrderNo)
    2. Sub ReStoreOrder(OldOrderNo As Single)


    Anytime I pass a variable between subs I must re dim it in the ( ) and also name it in the call of the sub in (). Is there no way to make it available to the other sub at the same time, or do this just once? Thank you Bthayer

    This is my first question. I am having trouble passing a variable between two subs. The variable in the second sub is always zero.



    The first sub is an object, Sheet1.
    The second is a module.
    I thought Public ment it could be used by other subs.


    I am a very base beginer. Past threads were very helpful on other issues, but this is so smiple I did not find a solution. Bthayer