Hello, I am stuck with the problem where I have to match two sheets from the same workbook. One is kind of master sheet, I vlookup for the similar recods but I need to add the records from master sheet to the second sheet that are not found in the second sheet. The record to be added to the absolute position of the master sheet. I can't get the formula to insert a row and then add the data from the master sheet. Or May be one formula/script which would insert matched and mismatched records at the absolute position in new sheet. eg. I am matching the records on the day column and if there is a day thats weekly off then that shows in Master sheet but not another sheet. So Now I want to add that weekly off day to my second sheet and Move the existing row to next row. Sorry I cant share my files due to security policies.
Thanks in advance. Rupa -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to google-spreadsheets-api+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
