Dear experts,

Please put me out of my misery.  After a long process of pulling data from a PDF to put into Excel, I now have 2 tabs of data. It was beautiful and served the purposes initially explained.  Since then, more requirements have surfaced and I also need to track status. 

I’m providing an simplified example to protect the sensitivity of the real data.  

Offices tab

OfficeAsset Set112231

Assets tab

Asset SetAssetDescriptionDelivery DateDelivered?1L-shaped DeskIkea 1003  1Ergo ChairWayfair 40  1BookshelfIkea 502  2Basic DeskWalmart 20-7474  2Basic ChairWalmart 20-9348  2

Bookshelf

Ikea 502

Data is in a single Excel worksheet. One tab contains all the offices in a building. The second tab contains the breakdown of items that belong in that office. I made sure to have the Asset number relationship in the tabs because I’m pulling this data into a different format for use elsewhere.

(Side note: the items that make up an asset set could exist in another asset set.; see Bookshelf) 

I add 2 new columns in the Assets tab for Delivery info since I need to know whether the item was delivered to the office, for all items, for all offices. 

I can do the Index Match formula to find the Asset Set value in the Offices tab but I couldn’t find any way to select all the rows in the Asset tab, Copy, and Insert Copied Rows under that referenced row on the Offices tab. 😕  I don’t know VBA or Macros except to copy and tweak.

I have 1000 rows in the Assets tab and 300 rows in the Offices tab.  I really really don’t want to do this manually if I can avoid it.  I’ll need to do this as more office buildings get updated equipment.

In the meantime, I will start this process manually;

Create a new tabCopy Office row, paste into new sheetCopy group of rows from Asset tabpaste under office row (starting at column B to preserve the column heading detail)Rinse and repeat.

I hope someone has an amazing solution. Thanks in advance for your brain.

​Dear experts,Please put me out of my misery.  After a long process of pulling data from a PDF to put into Excel, I now have 2 tabs of data. It was beautiful and served the purposes initially explained.  Since then, more requirements have surfaced and I also need to track status.  I’m providing an simplified example to protect the sensitivity of the real data.   Offices tabOfficeAsset Set112231 Assets tabAsset SetAssetDescriptionDelivery DateDelivered?1L-shaped DeskIkea 1003  1Ergo ChairWayfair 40  1BookshelfIkea 502  2Basic DeskWalmart 20-7474  2Basic ChairWalmart 20-9348  2BookshelfIkea 502   Data is in a single Excel worksheet. One tab contains all the offices in a building. The second tab contains the breakdown of items that belong in that office. I made sure to have the Asset number relationship in the tabs because I’m pulling this data into a different format for use elsewhere.(Side note: the items that make up an asset set could exist in another asset set.; see Bookshelf)  I add 2 new columns in the Assets tab for Delivery info since I need to know whether the item was delivered to the office, for all items, for all offices.  I can do the Index Match formula to find the Asset Set value in the Offices tab but I couldn’t find any way to select all the rows in the Asset tab, Copy, and Insert Copied Rows under that referenced row on the Offices tab. 😕  I don’t know VBA or Macros except to copy and tweak. I have 1000 rows in the Assets tab and 300 rows in the Offices tab.  I really really don’t want to do this manually if I can avoid it.  I’ll need to do this as more office buildings get updated equipment. In the meantime, I will start this process manually;Create a new tabCopy Office row, paste into new sheetCopy group of rows from Asset tabpaste under office row (starting at column B to preserve the column heading detail)Rinse and repeat. I hope someone has an amazing solution. Thanks in advance for your brain.    Read More

​