Hello,
I'm hoping someone can help me as I am very new to VBA and I'm sorry if I don't use the correct terms . I have a workbook where each worksheet is a certain year(2012, 2013, 2014 so far). I need to write a macro that if there is a value(amount remaining at year end) in a certain cell(S23) then I would like to paste this value as well as a range of data (the person's information) into the next worksheet into a certain range to carry forward to the next year. I would then need it to look in cell(S24) and so on....I figured out how to do this with :
However I need this to happen for 30 rows in one worksheet X multiple worksheets and am wondering if I can do this with a loop as copy and pasting the code and updating the cells would take a long time. It also would be nice as then I don't have to update it for all the years.Please Login or Register to view this content.
Right now I have it pasting into a certain range but it would nice if when the data was pasted that it searched for the first available row in the certain range so I don't end up with empty rows.
Thank you so much for your help!!
Moderator's Edit: Use code tags when posting code. To do so in future, select your code and click on the # icon at the top of your post window.
Bookmarks