copy & paste workbooks

I have a workbook that is used to calculate data. There is a range on the workbook "P2:T2" that needs to be copied and pasted to a log as a record that it has been used. My problem is I don't want duplicate data on the pasted workbook. Is there a way to look for if there is already repeat...

Hi all, im quite new to vba, i have a code as below, 1. User enter unit and name 2. Check if date & unit and name correct 3. Copy range A8:F30 to new workbook at C:\Users\Abby\VBA\test.xlsx It is append to next row. 4. Then clear the content that filled after save There is no bugs when i...

I have two spreadsheets that have stock information for two departments, "Goods in" and "QC". I am trying to update the "QC" sheet automatically from the "Goods in" sheet. When a date is inserted into the "Goods in" sheet (column w) the "part no (j)", "quantity (k)" and "date released (w)"...

I need help coming up with a formula in vba to copy and paste sheets from a temp workbook toanother work book. These are the methods I have come up with and tried but don't work or don't know how to so if any one can help or has ideas that would be great! 1) Solution:Search the names of the...

Hi there and thanks in advance for any help and tips. So I am new to VBA and have just started playing around with it about two weeks ago. I have been searching and haven't been able to find a solution for the problem I am hoping to solve. I have two folders. The name of the first folder is...

Hi Is there a way of automatically copying cell data between workbooks without having to open both workbooks. I am recording student attendance - each class has a dedicated workbook where absence is entered and a total created. I would like to copy this total into a separate workbook...