Hi
I’m trying to get some code to write numbers when a set of numbers are found. I have copied an Excel sheet (just a very small example of what I use so I need specific cell locations to alter the code). To make it as clear as possible if I could draw your attention to the Excel sheet. I have a step by step process of what I’m trying to do.
Below I’m using the found number in cell B4.
1) The code must first search the range B4:B10, B13:B19 (need to be able to change) for any sets of numbers (1-1, 20-5, 7-7 etc).
- For each set of numbers found (B4 would be the first) the code must match cell A3 the “1-1” by searching specific cells H3 and H12 (cell locations in the code so it can be changed).
- The code also has to match 5.45 in cell C3 and search cells J3 and J12 (again need to be able to change in the code) for a match.
- It would find the 1-1 in cell H12 and 5.45 in cell J12.
- The last thing to do is match the line number which is in cell A4 which is 1 with line number 1 in cell H13. Write the contents of cells I13 to cell C4, cell J13 to cell D4 and cell K13 to cell E4.
2) The code would then move on to the next found set of numbers (cell B16 in this example) and repeat the process.
I really hope this is clear, not always easy to write it down. If it’s not clear please let me know so I can clarify it some more. Thanks so much for all your help.
[ATTACH=JSON]{"data-align":"none","data-size":"full","title":"WRITE NUMBERS TO CELLS.png","data-attachmentid":1216316}[/ATTACH]