is there a way to take info out of a BOM and insert it into a general table after adding text to it? for example if i have a BOM table with "part name", "description" and "quantity" now i need to create a new table that takes that info and puts it into a second table with "7+part name", "description" and a bunch of other columns. can i do this with a macro?