Hi everyone,
My problem is this: I have a spreadsheet that I import data in to columns A:E (name,site,contract,manager and Id) next to this in columns F:Q is manually entered data (skills). What I want to happen is when the imported data is updated, the names etc move up and down, and I want the cells in the manually updated columns to move in line with the changes. I should also note that all columns have an autofilter (if that makes a difference) Can this be done??? Please help, I've not got a lot of hair left!
My problem is this: I have a spreadsheet that I import data in to columns A:E (name,site,contract,manager and Id) next to this in columns F:Q is manually entered data (skills). What I want to happen is when the imported data is updated, the names etc move up and down, and I want the cells in the manually updated columns to move in line with the changes. I should also note that all columns have an autofilter (if that makes a difference) Can this be done??? Please help, I've not got a lot of hair left!