At least we both did it the same way! if you had to do this regularly, say daily or weekly, they i would say a macro is the best way to do it or if y...
Manually this can be done by 1) Unmerging cells 2) Text to columns with only the other delimited box selected and do ctrl+j (line break) 3) as the ...
are you saying the red button is not ungrouping? I had a quick look at your code and i think there might be 2 problems. 1) you had the if then e...
Chiew Yen Chuah said Hi Purfleet, The path that i put was correct. It can work when i put into your file. However, it doesn't works in my file an...
No problems, hope it helps. Let us know if it needs any amendments Purfleet
It might have been a couple of issues 1) the format when pasted into the webpage then pasted back in to the VBE might not be quite right (spaces an...
Morning have you seen this blog post? The actual code to print to PDF is fairly straightforward, below is a snippet that i have used in the ...
Hi Muhammad I am not really sure what you are after - do you want Column C to be 1001, 1002 etc? What does PO mean? What relevance is the 1000? ...
Hi You can just use filter and copy and paste in VBA Sub ExtractAndCopy() 'Declares Varibles Dim copyRange As Range, pasteRange As Range '...
Hi That is a very impressive formula! Can you add a little more context? Please attach an example work sheet so we can see what it is doing P...
Sorry shane, the link has expired. Can you keep it live for a few days in case i miss it again Purfleet
Can you attach an example workbook so we can see the code that is being used and how the formula is interacting with other cells? Purfleet
Hi Ben Do you want the percent to change depending on the Risk? So High would be 80%, Med 60% and Low 40%? I have never used Google Sheets but t...
Morning John What triggers the sheets to be unhidden? is it the check boxes on the bidder profile? I have been looking around the form and noted...
not really sure i understand what you really want. can you attached example workbooks?