Hello, My excelsheet contains weekly prices in the rows. The header in the columns contains the name of the product whereas the first column contains the date. Now, I want to calculate the price change for each product on every date and to export it to a new worksheet called 'Input'. Furthermore, I want to have a dynamic approach to the rows and columns. In other words after every week a new row with price information is added and it could also be that a new column is added or deleted. How can I make this work in Visula Basic. Looking forward to your reply.
Find latest posts