L
Legacy 371743
Guest
Hi all! I have been searching for hours for help on the forums but am still at a loss... Maybe you guys can help me? Basically I have a workbook called "Book1.xlsm and in it I have a command button that I want to be able to click and export data contained in cells [C2:F2] to a new document titled "Book2.xlsm". Also each time I click I want it to populate a new row with the said cells so I can compile all of the data and not overwrite any. Like a range +1 type of deal. Lastly is there any way to do this without the "Book2" document actually opening up and displaying (I want it to stay in the background)
I would be thrilled with any help you guys can give me!
Thanks
I would be thrilled with any help you guys can give me!
Thanks