I have a list of Titles on Sheet 1 in Column 1.
I want to copy the first Title in Column 1 on Sheet 1 and paste it on Sheet 3 in Cell A1.
Once the Title is pasted in Cell A1 on Sheet 3, formulas will be calculated in Cells B1:D1 on Sheet 3.
I then want to copy Cells B1:D1 on Sheet 3 and paste the values on Sheet 1 next the respective Title.
After that is completed I want the macro to carry onto the rest of the Titles in Column 1 on Sheet 1 until every Title has its respective outputs from the calculations next to it.
I understand that there are probably better ways to accomplish what I want and that if I attached my file you would be able to better help me but I have tried that already and it just doesn’t work out. I cannot paste my original file due to sensitive information and it is too difficult to re-create a workbook that illustrates my problem but leaves out the sensitive information. So if you could please do you best to help I would really appreciate it. I understand what I’m trying to do may be crude but for the sake of getting this project completed I want to proceed in this fashion and I will hopefully refine the workbook and code in the future. Thank you very much!
Bookmarks