-
Populating values in a range based on inputs in another range?
- This topic has 1 reply, 2 voices, and was last updated 1 year, 1 month ago.
AuthorHi,I have a set of data with Product name in rows and Customer names in columns. In input table (as attached snip), range B6:F20 will contain the order volume. In order to generate order in ERP, I need to build the output table (as attached snip) as shown. In output table range H5:J5 will remain constant as header and the output table will be auto generated based on order volume of products for each customers in Input table.I am trying to build any excel formula or VBA to build the output table.I am using Office 365.Could you please help me to sort the problem??Thanks in advance.ShazzadViewing 0 reply threadsAuthorViewing 0 reply threads