I have a block of cells (multiple rows and columns) that is the consolidation of every combination in the file. Under the conso, there's a block of cells for each combination. The combination are in columns A to C. So for each combination, I want Excel to copy/paste the first block of cells (like a template) to the other combination. It'll be easier to understand once you open the file.
Open the file located here: https://easyupload.io/87gwql
What I would want is a way (probably VBA) to copy cells E121 to AU236 and paste it on the same row where there is something in column A (so when column A <> 0 or ""). So in this example, it would paste it in E240 and E359. Then, copy/paste value everything under row 236 (so everything that's been copied). If possible, I would like the macro the delete everything under row 236 first, then copy/paste and copy/paste value.
The reason being that the data (and so the combinations) can change each month. Also, there will be functions in the block of cells, that's why we copy/paste first for them to recalculate based on the combination and then copy/paste value. For now, I've linked the combination in columns A to C manually, but there can be up to 150 combinations possible (which can be seen in the Master tab), so that's the reason for the copy/paste value, the file becomes slow otherwise.
Ask away if something isn't clear.
Open the file located here: https://easyupload.io/87gwql
What I would want is a way (probably VBA) to copy cells E121 to AU236 and paste it on the same row where there is something in column A (so when column A <> 0 or ""). So in this example, it would paste it in E240 and E359. Then, copy/paste value everything under row 236 (so everything that's been copied). If possible, I would like the macro the delete everything under row 236 first, then copy/paste and copy/paste value.
The reason being that the data (and so the combinations) can change each month. Also, there will be functions in the block of cells, that's why we copy/paste first for them to recalculate based on the combination and then copy/paste value. For now, I've linked the combination in columns A to C manually, but there can be up to 150 combinations possible (which can be seen in the Master tab), so that's the reason for the copy/paste value, the file becomes slow otherwise.
Ask away if something isn't clear.