

December 1, 2020

When worksheet (A) is refreshed with added or updated entry information and if the entries row order is rearranged will the "status" column with "active" or "inactive" move with the original data or is it tied to the row?
I tried to explain in the attachment, might have made it clear as mud
Using 365, mostly desktop version


Trusted Members

October 18, 2018


VIP

Trusted Members

December 7, 2016

Hello Doug,
I suppose the status is tied with the name, so the easy way to handle such scenario is to create a table/list containing names of those that are inactive, then import that list to PQ and you set the status in PQ based on that. Of course, those not in the inactive list are active.
Br,
Anders


December 1, 2020

Interesting idea, have to be careful not to get caught in a catch 22 scenario, when I try to automate this.
But you have given me an idea, maybe if I use PQ to create two worksheet, "Selection" worksheet with the 4 columns and a "Status" worksheet with just the "Name" column from the source, then I add the "Status" column.
I then could use PQ to merge the two worksheets by "Name", to a new worksheet which would contain the 5 columns, then use this worksheet to create the "Project" worksheet.
I'll try this and let you know, thanks for your input.
1 Guest(s)
