If and when the data is read into the file you can add a macro that removes all spaces and unallowed characters and you can also change the currency s...
What if you switch the columns?
Great, let us know how it goes
Hi Tracey, First of all to mention the Excel version you're using, I suggest you place it in your user profile so it's visible when you post. Si...
Looking a little further you have to check if the data validation is copied too. I think this is where the problem lies. You need to check if a ...
The cose reads okay and I don't see any issues there, but which 'dropdown menus' are you talking about? Another point if you require help is to ind...
Without the data to help i would suggest you move the On Error Goto 0 line to after the If PickData ... and see what happens
Hi Mark, I haven't forgotten you but I don't know where the time goes. Cheers, Hans
I placed a formula in column B and use the data in columns M and N If you are not using excel 265 or 2021 or later it will not work (that's why yo...
I integrated the code here, just to make it easier Remember, right-click cell F2
Just for fun, not a hyper link but it works, try this Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean) If ...
Hi, you're one of the many examples that show that GPT is going to cause many issues with would-be programmers. You find a code that looks lke it d...
Clear, I'll check and see if I can come up with something, I'm not that hot with Pivot Tables
Just a point of attention, in your question you talk abou Sheet 2 which is not named as such. I also suggest you indicate the Excev version you're ...
Hi Boyan, I would suggest you record a macro that saves the specific worksheet as pdf and you place this pdf file in your share