offset values with All decimal places

[Mohamedazees]

Dear Sir,

I have an issue with my Excel Inventory tool the Problem is I am not able to fix offset values with decimal Decimal Places in module1 since the unit I used in this workbook is CBM which is having 4 decimal places.
That is I needed to offset the value in my log sheets Column D with four decimal places. please help us to resolve the issue.
I have herewith given the dropbox link to download the workbook.

FIFO_Inventory2Cogs (2).xlsm

Shared with Dropbox

www.dropbox.com

 

[sijpie]

I'll have a look at it in a few days

 

[sijpie]

Just set the number-format for the range to 0.0000

Add the last line of the code below to the correct spot in your code:

....
        Set Destination = LOG.Cells(LOG.Rows.Count, "D").End(xlUp).Offset(1, 0)
        Set Destination = Destination.Resize(UBound(QtySold), 1)
        Destination.Value = Application.Transpose(QtySold)
        Destination.NumberFormat = "0.0000"
....

 

[sijpie]

By the way, not everbody helping here is a 'sir'...