i know this is an access forum but wasnt able to get any responses in excel forums so was wondering if i can have some help
i have 2 files (key.xlsx and test.xls)
i want to create a button in excel with macros where it opens up another workbook (my documents/key.xlsx) and look at the text in rows A2 through A29 up to column C. If there are any rows that are different from the current file thats open (test.xls), starting from A8 and down, then insert these different rows from key.xlsx into test.xls and put "0" as values for columns 'ticket count' and '% total'.
key.ziptest.zip