I dont know if I have to do a Match or Index formula to solve this problem!

[mcain1981]

Hi Everyone!


On Delete worksheet I need to do a look-up to copy all columns and rows from both Ruhle_customers and Ruhle_prospects worksheets that the first column says No-Delete.

I attached a portion of my workbook as an example.

I cant get it to pull from both worksheets......

Can anyone help me please!

Thank you in advance for your help!

[rcm]

here is the macro way to accomplish this

A question what to do after you transfer the record to the DELETE tab

[mcain1981]

I still want it to leave the row of data in the original worksheet. Is there anyway to make this run automatically from both worksheets? Also, when I run it, it recopies the same rows as before.

Thanks so much for your help!

[rcm]

I know that... I'll code it and flag the copied records... I'll try to make run automatically..

[mcain1981]

You're the best!!! Thank you!!! You've made my day!

[newdoverman]

The data from two tables can be combined into one table for this exercise. Copy the headers from one of the tables and paste on a new sheet. Select a range larger than the data in the table and enter a formula like =table1 with Ctrl+Shift+Enter and the contents of the table will be inserted into the range.

It combines all the NO-DELETE data from both tables.

Upon further testing, this will only work once unless you the ranges that you assign to each table are large enough to handle new data added. Once the range is filled, no more data can be added until rows are inserted and the range re-selected and re-assigned to the table...This is a set-up that requires maintenance in order to work for extended data entry in the first two tables.

I am going to do further testing to see what I can find out.

[mcain1981]

This is fantastic! Thank you both for your help!!!

[newdoverman]

You're welcome

Glad to have been of some help.

[rcm]

here is the automated non-repetitive version. If you choose NO-delete it will transfer it!!!