Posts by JohnDrew

I need to catinate some text information with a blank line between.

This goes on a label for exporting.

For example:

Item number: 123 (this comes from A1)
Description: Display Kit (this comes from B1)
Made In: USA (this comes from C1)

I have catainated this: "Item Number" & "A1" ....then I need a carriage return??
to start the next line .

" Item Number: " & "A1" & char(10)?? &"Description: " &"b1" & Char(10) &"Made In " & "C1"

Desired result:

Item number:123
Description: Display Kit
Made In: USA

Thanks

I need help in copying a range down only to the last used cell, over to the last used cell on sheet 2.

Then subtotal. (This is YTD sheet)

The next time I enter data, and run the macro,

do the same and reset the subtotals and add the new data.

Re: Copy Data From A Row to Spreadsheet And Print

Everything works okay except the printing. It only prints the first page and then the printer stops. I have to clear the print que to start other printing.

I have tried this on two printers with the same result.

Is there another print command?

John

Re: Copy Data From A Row to Spreadsheet And Print

Yes,

But it only prints the first name. It will not go to the second name.

Re: Copy Data From A Row to Spreadsheet And Print

What I need is to:

1. copy the name from "A1" to "A10" sheet2

2. print sheet2

3. go down 1 and get next name

4. repeat until column "A" equals a " "

5 end

I have a list of names in column "A" worksheet1

I need to copy the name from "A1" sheet1 to "A10" on sheet2

Then print a range called "Document" from sheet2

Then get the next name "A2" sheet1 etc. down

Until it reaches a " " in column "A" sheet1

Can you help me?

Re: Inventory-move Shipped Units To Subtotal Sheet

Here is the file.

The problem I need help with is in moving the "ship" units to the "Total Shipped" and recalulating the sub-totals.

The ranges will always be the same for Begin, Rec, Ship and Ending

Thanks

I have an inventory sheet and wrote a macro to move ending units to begining and post as range value.

Then moved range "ship" to Total Shipped sheet and posted to the last row.

Recalculated and sub-totaled the Total Shipped sheet.

Then zeroed out Rec units

and Shipped units. This will allow new entries.

PROBLEM; I don't know how to post "ship" range in the Total Shipped sheet and calculate a new sub-total.

The macro didn't work.

Thanks,

Re: Change Formula Based On Cell Value In A1

I get a ref error on the attached. I want to use Shipping column "A" and Column "B" to change the formula.

By changing this the worksheet will use the desired shipped units. Once I get the formual for shipping, I can easily and quickly adjust the Receiving and Adj formulas.

What I have is shipping orders which come in and I cut and paste to the next column.

I need the formula to adjust to the new column.

Thanks

Re: Change Formula Based On Cell Value In A1

I still can't get the right answer.

I added the last paranthese and tried to make the new address absolute, so it doesn't copy down.. but it didn't work.

I tried to send up the file but I get a popup block. I don't know where to go to unlock it.

Re: Change Formula Based On Cell Value In A1

I tried the formula, but get a "Ref" error when I post it.

=SUMIF(SHIPPED!$A$3:$A$13,A2,SHIPPED!$B$3:$B$13)

I would like for the formula to change to what is in A1.. If I change A1 to C, I would like for the formula to replace A with a C in the formula.

SUMIF(SHIPPED!$A$3:$A$13,A2,SHIPPED!$C$3:$C$13)

Thanks

=SUMIF(SHIPPED!$A$3:$A$13,A2,SHIPPED!$B$3:$B$13)

I would like for the formula to change to what is in A1.. If I change A1 to C, I would like for the formula to replace A with a C in the formula.

SUMIF(SHIPPED!$A$3:$A$13,A2,SHIPPED!$C$3:$C$13)

Thanks

Re: Inventory Management

The worksheet by Biz worked best.

What I need is to be able to reset the inventories after posting the transactions.

For example:

Do a range value from the Ending to the Begin and then add one column
in the Shipped sheet and change the Inventory sheet calculation to now look at the newly column for the next shipment.

see sheet attached

Re: Calculate Time From Whole Numbers

Super..Two thumbs up for excellence.. Just what I was looking for.

Thanks

John

It is quicker and easier for me to enter times as whole numbers.

I tried to Catinate the number and enter the ":" in the middle. Example
I enter 815 and then =":" &RIGHT(a1,2) and get :15 but how do I add the 8 and convert the new number to time?

I have an inventory of about 100 items. I receive a list of the items shipped for the day. I need to match these with the master inventory and adjust the inventory. The same holds true with receipts and adjustments. Then save the file as the current date.

See attached

Can anyone help me? I have lsearched through the archivesbut can't find the solution.

Thanks

Re: Email Range To Suppliers Of Inventory

Great Idea! See attached.forum.ozgrid.com/index.php?attachment/21186/

Re: Email Range To Suppliers Of Inventory

Where is the list of Forum sections and how can I move it over?

I am 63 years old and just started and it is a challange to navigating your site. Please be patient.

John

I need to send an email to each of the suppliers their present inventories using Outlook. If inventory is "0", set high priority flag.

Example:

Supplier Item Qty Email address
A 123 10 [email protected]
A 456 2 [email protected]
B B10 20 Reliable.xom
B B11 0 Reliable.xom
C C22 9 [email protected]

Thanks John