Log In
Register
Home
December 1, 2020
Offline
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
Offline
Pictures are kind of useless and do not allow us to manipulate data. Suggest you upload a workbook that can be manipulated and tested with a workable solution.
VIP
Trusted Members
December 7, 2016
Offline
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
Offline
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)
