If its just a 1 to 1 match you want you cant go far wrong with index and match =INDEX('Risks List'!$F:$F,MATCH([@Name],'Risks List'!$I:$I,0))
Hi Tina Can you please upload an example workbook so that we dont have to spend time recreating the data.
No file attached. Dont forget to press upload
Please add an example workbook so that we can a) see what is going on with the actual data and b) we dont have to waste find recreating the data
Seems to work for me, where are you putting your formula in? Is always better to add an excample worksheet so we can see what is happening and we t...
Hi Ramzan I think i understand what you want to count, but not sure why you need a custom function or why the formula needs to be killed? I have...
Hi Steven Do you want the sub step to appear below the selection ie, the user selects 1.3 so you want 1.3.1, 1.3.2, 1.3.3 & 1.3.4 to appear bel...
I have added some loops at the bottom to copy over formatting etc Dim fRange As Range Dim tRange As Range Set tRange = Worksheets("Template").Ra...
Fair enough, so a bit of a work around but this is also dependant on your Pivot table being in the same format every time We have a couple of count...
Hi Marsil I have had a quick look and it seems you want a fairly comprehensive process automated – have you made a start with coding this or do you...
The first thing i would say is be careful of merged cells on the invoice - they are just about the worse invention Excel has ever had and will do more...
Luckily you only posted the question it at least 4 other forums
That makes sense, thanks. To avoid complication and the fact that it is in a dashboard i would go with a Staging table to calc everything and the das...
I am not sure there is a particulary easy way, but might be able to make it more dynamic. Just a question at the moment - in Period 1 you are calci...
Sorry i did this and forgot to reply, and i have just assumed what Phil has asked Anyway its a bit quick and dirty,b ut this might work Purfleet