It probably needs un-pivoting to make it in to proper data. I am no expert but belive that can be done in power query - can you upload a file rathe...
You just want to copy all the data in the various column G's in to one long column? Sub ConsolidateG() Dim ws As Worksheet Dim NextSummaryCell ...
Nothing attached, you need to click upload
Please attach a workbook rather than a picture so we dont have to try and re-create the data
Morning I am not 100% sure what you are after, but I will make a start working on the summary table in the top right comparing Wk43 with Wk42. On ...
I am not 100% sure what you are after as your drop downs are for description and Origin but the yellow fields mention IGST, CST & CGST which are p...
Do you have an example of the code you are using? Please attach a workbook
We really do need work book examples rather than pasted in data as we just waste time recreating the data you already have. The issues you have is ...
Can you please describe what you are trying to achieve? Is column C actual sales? and row 2 the target? do you want the percentages to work out ...
I think it is because you are trying to do the sumif down and across, =SUMIF(A2:A5,B10,F2:I5) The A2 to A5 is matching B10 and giving you f, if ...
Using Office 365 make it really easy, transpose & unique to get the headers then filter for the results =TRANSPOSE(UNIQUE(A2:A7)) =FILTER($B...
What version of excel are you using? it could make a huge difference to the complexity Also, please add an exmaple workbook rather than a picture s...
Do you mean like this? =INDEX(OFFSET(INDIRECT($H$10),,1),MATCH(TEXT($A10,"@"),INDIRECT($H$10),0)) Only tested on Excel 365 Also appears to wo...
Nothing attached mate - you need to press upload
Its much easier if you add a workbook rather than a picture as we dont have to try and recreate the data Try =IF(OR(M1>0,N1>0),SUM(K1:N1),0)