sage

  1. J

    Multiple Creitera

    Hi, what formula can I use for the data below, wan to find Sage ID and Account reference and get the amount $ for it. here is the data: <tbody> SAGE ID Type Account Reference Gross 100016 NorthwesTel 8327204 5794.25 100016 NorthwesTel 8327205 7705.03 100016 NorthwesTel 8335419...
  2. K

    Data Matching from Sage

    Hi everyone! New to the forum so apologies if this has been covered. I am seeking help on how to match data from a report exported from sage and converted to csv to match another excel spreadsheet. So I have an excel master spreadsheet with names of customers with their monthly sales figures...
  3. R

    Backfill of Data Based on Subtotals with if Condition

    I am looking to automate the backfilling of data into lots for an inventory count sheet template. Basically, I need to take the physical count quantites from Col F and distribute them across the lots in Column D for each item. The results are shown in Col G. It seems like an if condition to...
  4. L

    Using 3rd Party Excel Addin within a MACRO (Sage Excel Addin)

    I use Sage Line 50 Accounts which comes with an Excel Addin. When recording a MACRO within Excel 2007 I am unable to "call" any element of this MACRO. Has anyone had any experience with either this 3rd party addon, or indeed any 3rd party addon within Excel and how to get Excel to see the addin...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top