ok so I have 2 excel workbooks. WB1 and WB 2. What I want to do is transfer Information from WB 1 to WB 2. The thing is that WB 1 is updated every month. WB 1 and WB 2 have the same structure, so WB2 is just a new workbook that I need to fill up with info from WB1, and I need it to update automatically. One way to do it is maybe pick a variable in column 1 of WB1 and somehow take whole row and transfer it to WB2, but i dont know how to do that. I NEED TO DO IT WITH MACRO. I hope someone can help me. Thanks.
Find latest posts