LinkBack URL
About LinkBacks
Deleted the post.
Deleted the post.
Last edited by Lakshaay; 06-13-2024 at 10:26 PM.
Administrative Note:
We would very much like to help you with your query, however your post does not comply with our guidelines
Please take a moment to review how to add code tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.
Please see Forum Guideline #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here.
I have added the code tags for you today. Please take a few minutes to re-read our guidelines and rules that you agreed to when you joined and comply in the future.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Change to
Please Login or Register to view this content.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
It would be helpful if you could say which line of the code gave you the error and the exact wording of the error.
Meanwhile, you might wish to add a path separator to the end of your SorucePath string...Please Login or Register to view this content.
Place this macro in a regular module in your Master file. Re-save the file as macro-enabled workbook in the same folder as your source file. Run the macro.
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
thanks alot
You are very welcome.
Deleted the post.
Last edited by Lakshaay; 06-13-2024 at 10:27 PM.
I don't see this in the code I posted in Post #5.Dir(filePath) <> "" Then
Deleted the post.
Last edited by Lakshaay; 06-13-2024 at 10:27 PM.
Have you tried the macro I suggested in Post #5?
Deleted the post.
Last edited by Lakshaay; 06-13-2024 at 10:27 PM.
Deleted the post.
Last edited by Lakshaay; 06-13-2024 at 10:27 PM.
It would be easier to help if you attach your file. See the yellow banner at the top of this page for instructions on how to attach a file.
Deleted the post.
Last edited by Lakshaay; 06-13-2024 at 10:30 PM.
Deleted the post.
Last edited by Lakshaay; 06-13-2024 at 10:30 PM.
Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your "New" sheet in the Master and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Enter a month in cell W2 and press the ENTER key.
Please Login or Register to view this content.
Deleted the post.
Last edited by Lakshaay; 06-13-2024 at 10:28 PM.
This version of the macro will ask you if you want to copy all the data or just a selected range. Click 'Yes' or 'No' accordingly.
As far as VBA is concerned, it is an extremely powerful tool that can be used to automate tasks. I found that the best way to learn VBA on your own is to use on-line tutorials, searching the web for specific areas of interest and following forums such as this one. The volunteers on sites such as this one are invaluable at providing help. I would suggest you keep a file of codes that you find useful and in this way you can build up a library that you can refer to. A lot is also trail and error. The very first post in this Forum (highlighted in blue) is a good place to start. The following links may be of help:Please Login or Register to view this content.
http://www.snb-vba.eu/index_en.html
https://excelmacromastery.com/vba-dictionary/
https://excelmacromastery.com/excel-vba-array/
https://www.excelforum.com/excel-pro...materials.html
The more you practise, the better your get at it. Good luck with it!!!!
Deleted the post.
Last edited by Lakshaay; 06-13-2024 at 10:28 PM.
Replace this line of codewith this linePlease Login or Register to view this content.Please Login or Register to view this content.
Deleted the post.
Last edited by Lakshaay; 06-13-2024 at 10:28 PM.
Lakshaay,
Just a question:
Each monthly report file you uploaded in Col.A starts from "June" for few rows and the other are numbers.
Is it always like this? I mean you have multiple data types in one column? i,e, String & Number.
Deleted the post.
Last edited by Lakshaay; 06-13-2024 at 10:29 PM.
Deleted.......................
Last edited by jindon; 06-13-2024 at 10:18 PM.
Deleted the post.
Last edited by Lakshaay; 06-13-2024 at 10:29 PM.
Sory, but I don't like to touch the code written by someone else.
Perhaps. someone else could help you.
master_report file there in Module 1, I have codes to append either the full data by overwriting or to select only few rows and append after the last row. Now until n unless I put the code in sheet 1 it does not work, so how should I modify the codes so that the codes in Module 1 work for sheet 1, also the code in Module 1 works when I type the Month name in ##w2 cell and it find the file in the same folder, here after appeding the file the Month name doesn't disapper, what should I do to make it disapper once the data has been copied or appened.
@lakshaay
do not delete parts of threads or the original post. This is a data base that is intended to help you and any others having similar issues. If you continue to use this approach to your posts, you will find yourself with a time out and possible banishment from this forum. Follow the rules you agreed to when you joined and do not modify your posts by deleting sections of them. This thread is closed to future additions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks