Assistance needed for Sage export - how to 'clean'?
In my job, we often get given exports from Sage for transaction breakdowns - I think I have managed to write formulas to clean most of this data, but the one thing I am struggling with is how to get the nominal code to be returned
PDF below - but similar enough to excel (given that Sage excel exports are not excel0friendlt at all) - what I want is on another sheet, to return the n/c but to put it on the right one - the nominal activity on the same excel often covers multiple codes - so i don't know how to get (or if i can) a formula to basically look at the nominal code above type for example, then return that on everything below until a break etc... explaining badly I think
Ideal solution would be formula-driven - this is because I am trying to create a 'cleaner' that everybody else in the office can use
I imagine a macro can work well, but I just try to avoid macros where possible in documents that others are using - i like the "copy and paste in this tab with no changes" approach
Power query also probably a good one - but maybe the least preferred - if it was just me - I would power query or macro, but given rollout to team, copy and paste with a front sheet returning required values is needed.
thanks in advance
[link] [comments]
Want to read more?
Check out the full article on the original site