Hi Guys,
A massive thank you to everyone involved in my previous posts and help to others, also enabling me to investigate to find answers to my queries . My Excel knowledge is slowly creeping up, helping me to improve the spreadsheets I work on (in some cases improving 4 hours work into 10 minutes!).
I have an issue with a spreadsheet which is exported from a source where the format cannot be changed. Currently in order for this spreadsheet to work when I import into my main document, I have to manually change all items in the example below from the left image to the right image (currently 100 + "Products"). The change is to put the "Code" onto the same line as the "Branch" below then entry, and repeat where applicable (Branch will be 1 to 15 lines)
This action allows a =SUMIFS formula to work (this does work really when so I'm hoping there could be maybe a VBA code (which I can then assign to Macro enabled button) can be written to avoid the manual entry and speed up the process immensely and avoid potential human error.
Any questions please ask.
Thank you
Shaun
A massive thank you to everyone involved in my previous posts and help to others, also enabling me to investigate to find answers to my queries . My Excel knowledge is slowly creeping up, helping me to improve the spreadsheets I work on (in some cases improving 4 hours work into 10 minutes!).
I have an issue with a spreadsheet which is exported from a source where the format cannot be changed. Currently in order for this spreadsheet to work when I import into my main document, I have to manually change all items in the example below from the left image to the right image (currently 100 + "Products"). The change is to put the "Code" onto the same line as the "Branch" below then entry, and repeat where applicable (Branch will be 1 to 15 lines)
This action allows a =SUMIFS formula to work (this does work really when so I'm hoping there could be maybe a VBA code (which I can then assign to Macro enabled button) can be written to avoid the manual entry and speed up the process immensely and avoid potential human error.
Any questions please ask.
Thank you
Shaun