Hi everybody,
I am a quiet a beginner to VBA and my boss asked me to write a macro to process some data in our excel files. After 1 hour of using google I still have no clue and really hope that you guys can help me. Probably it is an easy task for most of you. So here is the problem:
Input:
For every month i have a different sheet in my excel file, January to December and at the end I have something like a balance sheet. In each monthly sheet I have one to ten different projects with various data for each project. The data for each project is the same (it's standardized) and it is saved from K96 to K136 for project one, K142 to K180 for project two and so on...
Output:
I want to create a button next to each project, which copies the values of this specific project, let's say K96 to K136 and appends the data to the balance sheet in the same order. I don't want to copy every project to the balance sheet so the macro shouldn't process like: copy data from Project 1 January and add it to B1-B40 of the balance sheet and Project 2 January to C1-C40. But it should append it to the right. So it should check for blank cells.
I hope you can understand my problem. It is quite hard to explain this in text...but I am very happy to get some help!! Thanks a lot guys.
Greets
VBegginerA
Bookmarks