Forum

Hi Alison, You can use the Transpose function as explained here: Use OFFSET to get the range and then wrap it in TRANSPOSE. Regards Phil

I'll check this, thanks for letting me know.

Hi, Can you provide the context for this, it might make it easier to work out a solution. Why are you trying to do this? In your examples, you ...

Hi Alison, I've raised this with the SumProduct team. Regards Phil

Hi Alison, I've checked with the team who produced the course and they are working on getting this fixed. Regards Phil

No worries 🙂

Hi John, There's no attachment. Regards Phil

Hi, Can you supply some example data and the result you expect. As much detail and info as possible 🙂 Thanks Phil

Hi Charlie, If the manufacturer doesn't provide a means for you to get the device data into Excel then I'm not sure how you would do it. Microso...

Hi Arun, Please see attached workbook. This sends email using Outlook so you'll need that installed. Emails are sent 'silently' - they aren't dis...

Hi Alison, Yes, you have to copy the entire format in one go. Please see attached workbook, which includes the custom format. To recreate thi...

Hi Arun, the code for emailing PDF's here should help you Regards Phil

Hi Julie, Are we deleting rows or columns? Which column(s) would pto, web cam, employee id etc appear? In order to look for something specifi...

Hi Julie, Yes this can be done. But the final macro will depend on what your data looks like. Can you please supply a workbook with data? Rega...

No worries Dan