consolidate different excel files then delete content of the original file

[melody10]

hello

would like to give my thanks in advance for whoever would take the time to look into this

attached is my file which consolidates data from different excel files. the consolidation part is working ok. but i need to add an extra function such that after the data have been copied, Columns A:k (starting row 2) in the individual (source) excel files will be deleted. So that on the next time i update the dashboard, it would only copy new data.

i hope i express myself clearly and thanks once again.

ps. also would it be possible that when i click on update, it will copy and paste the data as values? right now the formula is being copied

[Bernie Deitrick]

Try it this way - this copies entire rows (as your code did originally) but if you only need the values in A:K then that can be changed.

Please Login or Register  to view this content.

[melody10]

works perfectly... thank you very much