Hello! I'm having a major problem with figuring out if this is even possible on Excel. This is a project that I am working on at work and it is absolutely crucial that I figure it out as soon as possible. Unfortunately I'm not that savvy with excel and wasn't able to find the solution on any forums or online at all. I really hope someone will be able to help me out and that my explanation makes sense!
Currently there are multiple vendors that my company works with and there are contracts that these vendors must complete. There is a forecast created for the next fiscal year to determine when we believe that the vendors will be completing these contracts and returning them to us. On sheet 1, there consists forecasts that are broken up into each month, and columns include the name of the vendor, the name of who is managing the contract in my company, the relationship manager that both parties must work with, and the tier that the vendor is in.
This is an overview sheet, and on sheet 2, it contains much more information. There are many different contracts and steps that the vendor must go through, and these dates need to be documented which will be found on this sheet. To save time and eliminate repeating processes, I really need it so that all the information that was entered in sheet 1, is copied simultaneously into cells in sheet 2. At first it was a simple task by just doing =D11, but because there are spaces between the rows in sheet 1 due to the change of months and spacing, it creates gaps in sheet 2 and makes it look messy and not easy to work with.
My question is, is there a way to create a macro that copies the information from sheet 1 to sheet 2, while taking that information to go to the next available line?
Thank you!!
Currently there are multiple vendors that my company works with and there are contracts that these vendors must complete. There is a forecast created for the next fiscal year to determine when we believe that the vendors will be completing these contracts and returning them to us. On sheet 1, there consists forecasts that are broken up into each month, and columns include the name of the vendor, the name of who is managing the contract in my company, the relationship manager that both parties must work with, and the tier that the vendor is in.
This is an overview sheet, and on sheet 2, it contains much more information. There are many different contracts and steps that the vendor must go through, and these dates need to be documented which will be found on this sheet. To save time and eliminate repeating processes, I really need it so that all the information that was entered in sheet 1, is copied simultaneously into cells in sheet 2. At first it was a simple task by just doing =D11, but because there are spaces between the rows in sheet 1 due to the change of months and spacing, it creates gaps in sheet 2 and makes it look messy and not easy to work with.
My question is, is there a way to create a macro that copies the information from sheet 1 to sheet 2, while taking that information to go to the next available line?
Thank you!!
