Hi I am new to VBA and I have really been struggling to create a macro that runs smoothly On Sheet1 I have 8 values ranging from 1,2,4,5,-1,-2,-4,-5 that are entered into cell "D2" via VLOOKUP with a drop down menu in "C2". Is it possible that every time I clicked on the drop down menu in "C2" and populate "D2" with 1,2,4,5,-1,-2,-4,-5 that a macro can record on a corresponding row on sheet2 e.g sheet1 click "C2" Populate "D2" with value, Sheet2 "E2" would record the result, next click would be recorded in "F2" and the next would be in "G2" and so on. I know it sounds simple but I am finding it very difficult, I have all the functions working but really struggling here with the macro part and any help would be very much appreciated. I have 150 entries on sheet1 so if you can point me in the right direction I would very happily write out the 150 macros for each row if need be.
Bookmarks