If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
after external data refresh, Delete row of manual entries
I pull external data into columns A-D. The data fills 5 rows. I add two
additional columns E,F and manually enter additional info. As the work is completed I refresh the data and the rows of completed work will drop out of the data query results. Is there a way to delete the info in columns E,F if the original row of data is removed by a data refresh? I need the remaining data to match to the row where it was originally entered. ex. Column A | B | C | E | D | E | F Row 1 | -----------------| 1 | 1 Row 2 | -----------------| 2 | 2 Row 3 | -----------------| 3 | 3 Row 4 | -----------------| 4 | 4 Row 5 | -----------------| 5 | 5 After refresh. Column A | B | C | E | D | E | F Row 1 | -----------------| 1 | 1 Row 3 | -----------------| 2 | 2 Row 5 | -----------------| 3 | 3 Row - | -----------------| 4 | 4 Row - | -----------------| 5 | 5 Thanks for any ideas. |
#2
|
|||
|
|||
after external data refresh, Delete row of manual entries
"lschro" wrote: I pull external data into columns A-D. The data fills 5 rows. I add two additional columns E,F and manually enter additional info. As the work is completed I refresh the data and the rows of completed work will drop out of the data query results. Is there a way to delete the info in columns E,F if the original row of data is removed by a data refresh? I need the remaining data to match to the row where it was originally entered. ex. Column A | B | C | E | D | E | F Row 1 | -----------------| 1 | 1 Row 2 | -----------------| 2 | 2 Row 3 | -----------------| 3 | 3 Row 4 | -----------------| 4 | 4 Row 5 | -----------------| 5 | 5 After refresh. Column A | B | C | E | D | E | F Row 1 | -----------------| 1 | 1 Row 3 | -----------------| 2 | 2 Row 5 | -----------------| 3 | 3 Row - | -----------------| 4 | 4 Row - | -----------------| 5 | 5 Thanks for any ideas. The example above is what happens after refresh, That is NOT what I want. This is what I need: After refresh. Column A | B | C | E | D | E | F Row 1 | -----------------| 1 | 1 Row 3 | -----------------| 3 | 3 Row 5 | -----------------| 5 | 5 Row - | -----------------| - | - Row - | -----------------| - | - |
Thread Tools | |
Display Modes | |
|
|