Transfer edited rows only to new worksheet
Hi,
I manage a staff list of 3800 people.
i update this to another database via CVS file daily to add the updates.
due to the number of staff / cells it can’t cope so need to upload to updated rows only.
how to I do it so only edited / removed row details for that day are added to another worksheet instead of uploading the whole worksheet or individually
moving updated rows to this separate worksheet.
isn’t something a formula can do or is it VBA?
Hi, I manage a staff list of 3800 people.i update this to another database via CVS file daily to add the updates. due to the number of staff / cells it can’t cope so need to upload to updated rows only. how to I do it so only edited / removed row details for that day are added to another worksheet instead of uploading the whole worksheet or individuallymoving updated rows to this separate worksheet. isn’t something a formula can do or is it VBA? Read More