Posts by ady171

    Hi all,

    I have a spreadsheet which pulls data from Sage. There are two columns added on the spreadsheet which the user picks items, the and Department it is for.

    The issue I have is that if something gets added or removed from Sage and then the databases is updated, the quantity and department are no longer assigned to picked product row.

    Is there a way to keep these assigned to the selected row?

    e.g of what is looks like..

    Thanks guys

    Hi guys,

    I am trying to run this code but keep getting syntax error..

    Sub UpdateFormula()
    Range("K2").Formula = "=IF(ISNUMBER(MATCH(I2,'C1'!$I$2:I$66,0)),"","Not Found")"
    End Sub

    any ideas?

    Thank you

    Hi all,

    I am trying to import a value from Excel to Word using the bookmarks in Word but cannot get it to import fully i.e. $1203.10 would import as 1203.1

    Why is it missing the zero off the value and is there anyway to import it as its in excel in currency?

    How do I get it to import exactly as the value in N5 cell?

    I tried this with paste-special as link in Word but since the word doc is used with another excel file also it would have two values.

    Thanks guys