Why don't you just cut and paste into the same Excel sheet ? It would only take you 1 minute to do that.
Your 1st attachment is what I got. The outcome will depend on what you chose for the sort keys so. See post #3
Hi Paul My bad. I left out the Range("AG2"). I think I got overly excited when I saw your last statement and understood what you actually wante...
Hi David You are welcome. Glad to know you are able to figure it out. Cheers Sunny
Hi mymalone Did you select the entire area? In what way is the data not sorted properly? It is working for me. It will first sort column B based...
Hi Frans Q3 - You can right-click the folder's header and add a column TYPE to view the file extension. I couldn't find any non-VBA solution to ...
Hi Paul Is there suppose to be an attachment? From your statement My issue is that the first condition, If Range("TrueMonth1") Then, needs to...
Hi Frans For Q2 I believe the reason is because it is not practical to save the printer's name. If the file is only used at your office then maybe ...
Try this for Q1 It involves a macro Sunny
Hi Frans I can only help with Q3. You can try changing the windows setting to hide the extension for known file types. Hope this helps. S...
Hi Paul Thanks for your clarification. It does help. Please refer attachment. The code filters the table with the required criteria and check...
Hi Paul From what I can see, you only wanted to extract data from a table to another range based on some criteria(s). Am I correct? If this is w...
Hi mymalone In your column B, there are no duplicate colors for the same set of numbers. So if you sort by numbers first you will not see any diffe...
Hi David Give this a try. To prevent double/triple summing, I am matching the code in each cell of column B against the cell above. If it is the...
Can you attach your actual expected result? VERY IMPORTANT Which columns are you matching to get the net balance? Is your attachment the actual ...