Hi,
I'm very new to VBA, the macros that I do have are from internet research and are not something I've built from scratch. I have this macro that I've been working with:
B5:F14 is refreshed with new data and I need to append the new data to the running list in Column K. The problem is that whenever new data appears in B5:F14, all the data that I've logged in Column K refreshes as well, with the new data in B5:F14, instead of keeping the historical data. I'm wondering if modifying this macro to paste values into column K would fix this problem.Sub Append_Data_to_Master_List() Range("b5:f14").Copy Destination:=Range("k" & Rows.Count).End(xlUp).Offset(1) End Sub
If anybody could help me with this I'd appreciate it!
Thanks,
Christina
Bookmarks