I have an attendance tracking spreadsheet for my school in which I keep rows with student data. Each time I run an attendance report I'll have some of the rows with updated data. I want to be able to drop this new data in a new sheet then have a macro or VBA code to merge the old data with the new. The catch is that I've manually added other student info to the original data that needs to be kept. You can see a sample workbook with three sheets attached. The first sheet has the original data, the second would be the data that needs to be merged with the original, and the third is what the data should look like once merged. I'll be working with up to 500 rows of data each time it updates which is why I can't do this manually.
Hello Sir Im excel VBA macro and formula expert :) i can do anything in excel Sir please give me a chance for doing your job and im able to start doing your project right now Thank You Sincerely Prameswara