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.

Call ReStoreOrder(OldOrderNo)


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.

Public Sub RetriveOrder_Click()
     Dim OldOrderNo As Single
     OldOrderNo = InputBox("Retrive Order #", "Enter")
     Call ReStoreOrder
End Sub


Sub ReStoreOrder()


Sheet3.Activate
     Dim Det As Worksheet
     Set Det = Sheets("Detail")
     Det.Range("A3").Select
        Do
        If ActiveCell.Value <> OldOrderNo Then
              ActiveCell.Offset(1, 0).Select

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