Posts by Carim

Too bad you do not want to attach a sample file ...

You can test the following

ActiveSheet.Name = Format(cell.Value, "dd-mm-yy")

Hope this will help

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

Hello and Welcome the the Forum

Best thing to do ... is to attach a sample file

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

OK ... understand the priority ...

Regarding the macro speed and performance ... you have decided to remove :

'Application.ScreenUpdating = False
'Application.Calculation = xlCalculationManual

which were initially added ... exactly for your objective : improving speed and performance ... !!!

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 ...