I am trying to create an excel formula that will allow me to populate data from a master list into individual lists, but will update as necessary. We are trying to allow the consultants to know which insurance companies will pay for which HCPCS codes (or not), so I need to populate multiple rows of data (with the same category name) onto separate sheets, but need multiple columns of information to transfer.
Attachment 531571 For example, I would wanted all of the bathing/toileting systems category items to transfer to a tabe named bathing/toileting systems and would want all of the rows (E0240 & E0244 in this image) to transfer along with all of the columns of information (which insurance companies would pay/not pay) - I also need this information to be able to update itself as we add new data, which is why I need it to be a formula rather than copying/pasting.
I was thinking VLOOKUP could work for this, but I haven't found a way.
Any ideas?
Thanks!hcpcs.PNG
Bookmarks