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.
Hi,
Upload a representative sample of your workbook so that we can see the request in context.
Rgds
Richard Buttrey
If this was useful then please rate it appropriately.
Click the small star iconat the bottom left of my post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks