We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

I need advice re: excel formula please

Options
13»

Comments

  • Carrot007
    Carrot007 Posts: 4,534 Forumite
    Part of the Furniture 1,000 Posts Name Dropper
    ....but vba is not really ott, quite simple probably, could just be a function effectively and could even be produced as an add-in so can be added to every Excel workbook that might be used with the reports.


    Along those lines but different! I would go with a macro in a seperate sheet that would run on the current sheet and do the changes when run. That way you get to keep the sheet simple and ensure it loads into where it is intended. Just my thoughts though.
  • longforgotten
    longforgotten Posts: 1,093 Forumite
    edited 22 January 2019 at 8:43PM
    Thank you all for your help, you have all been very kind, it is very much appreciated.


    Please DO NOT spend any further time on this.


    Best I admit I do not understand the last few posts as I am not techie at all. It seems very much that if you come up with answer I will be too thick to apply it :(

    This is all QuickBooks fault and I shall get back to them.
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 350.7K Banking & Borrowing
  • 253K Reduce Debt & Boost Income
  • 453.4K Spending & Discounts
  • 243.7K Work, Benefits & Business
  • 598.5K Mortgages, Homes & Bills
  • 176.8K Life & Family
  • 256.9K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 37.6K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.