Posts by Carim
-
-
Thanks for your Thanks
-
In my humble opinion, you are over-complicating you own life ...
Hope another contributor will step-in and help you out
-
Thanks for sharing your solution for all Forum readers ...
and thanks for your Like
-
-
Surprisingly enough ... more than a week after your initial question ... still no feedback ...
-
Attached is your test file version 7 ...
All 9 Formulas have been incorporated into your macro ...
Please note since you have decided to remove all data, there is no means to check the results produced by these formulas ...
Hope this will help
-
Thanks for your Thanks ... AND for the Like
-
-
Hello and Welcome to the Forum
The best thing to do is to attach a small sample file ...
-
Hello,
You can use following formula to return even and uneven numbers :
Quote
=MOD(ROW(),2)Hope this will help
-
Hello,
Quote
The Vendor tables are abbreviated in the sample I sent just ...Could you please explain with more details how are the Vendor identified in your Jobs worksheet ?
-
Hello,
Could you please post the VBA code which needs to be fixed ....
-
So ... to be concrete ...
Is the next step to deal with Columns AQ to AY in worksheet Display ... and incorporate your 9 Formulas into your existing macro ...???
-
Hello again,
Forgot to mention, you can now combine Excel workbooks without VBA ...
A very easy solution is available with Power Query :
https://www.myexcelonline.com/…kbooks-using-power-query/
Hope this will help
-
Hi,
As soon as I have a moment ... will give again into your maze ...
-
Since everything seems dynamic ... i.e. new products constantly added ...
As suggested, would recommend to create a Product List for your suppliers ....
-
Thanks for your Like
-
Hello,
To be on the safe side, just a couple of things :
1. Have you checked the exact name of your sub-directory ?
2. What type of files (i.e. file extension) are you targeting ?
Hope this will help
-
By the way ... forgot to ask you why are they a total of 49 Products in your Jobs worksheet ...
and only ... when combining your 3 Suppliers ... 24 Products ...