Hi,
As part of something I am doing for work at the moment I have one main spreadsheet (payment changes [login to view URL]), which i need to update by copy and pasting from a series of spreadsheets each for a different month (starts 02-Payment changes September and goes up to 10-Payment changes [login to view URL]).
Now the tricky bit is that the dates on the main sheet will constantly be changing. For example it goes from September to february now currently, but soon march will be added, and september will be removed when the total outstanding balance falls below 50,000.
So how do I automate this without having to keep going into the code and changing the name of the worksheet to copy and paste from. Is there a way that I can type the worksheet name above each month and the macro will know this is the worksheet to go to in order to copy and paste the data.. I.e. the macro gets the worksheet name (where to copy the data) from the worksheet name i type in a cell. Looking for a way copy paste each month into the section without hardcoding the month name into the code.
If you know of another way then need to know what you are proposing before any agreement, also needs to be completed within 48 hours.
Hello, I see you require to upgrade your current Excel macro code. I assume you only need to be able to select the worksheet instead of changing the code every time. I have sent your a private message about my skills and previous experience in similar projects. I rest-assure that I will complete the work on time and deliver your the completed work to your satisfaction.
Hi,
I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel based projects. I am interested to work for your project. I will make sure that I deliver you the best with 100% accuracy in minimum time . Pay me only if you are 100% satisfied with my work, after project delivery. Please see my private message(PM) and sample projects attached with PM for reference.
Regards
Fibin
I have done too many Excel macros to count and am confident I can do this for you quickly and to your satisfaction. I back myself with no initial milestone requests. Please see PM for more details and clarifications.