temporary

Hi https://www.dropbox.com/s/lbmx4uus4481zgq/Extract%20Formula.xlsx?dl=0 The above link sheet has a product formula in sheet temporary and permanent. In the sheet, Master data Column A and B are the dates and product name. Each product has different formulations by 12 types of raw...

We have changed to a cloud server recently, which may be causing the problem, but has anyone come across this before? I have a folder with a "- Fees" workbook and a workbook for each member of staff. When the fee workbook is opened, it takes data from each of the workbooks in the folder, apart...

I have a workbook, which when OI open it, I see a temporary message: loading .net framework What is that for?

Hi, I added a Macro to my workbook which, when run, takes the current worksheet, saves it as a temporary file, emails it out and then deletes the file. It works fine for me but when another user tries to run it, they get the error message: Run-time error '1004': Method 'SaveAs' of...

Hello, I'm working on building an analysis tool and have hit a bit of a roadblock. I have a data set for a list of vendors in rows and type of scope across the columns. I also have a "Preliminary" vendor in the uppermost row of values which represents a budget. Both the count of vendors and...

Hi, I have a VBA which takes the current worksheet and emails it out (code shown below). However in the new file it creates and attaches to the email, the colours are distorted and not the same as the original worksheet. Does anybody know how to prevent this from happening. Many thanks Sub...

In previous versions of Excel I could make a temporary commandbar that held a control that I could "click" programmatically. Here's an example: 'Make a temporary commandbar with the button that fires the flag for followup dialog Set TempBar = CommandBars.Add(Name:="FlagDialog")...

I need help coming up with a formula in vba to copy and paste sheets from a temp workbook toanother work book. These are the methods I have come up with and tried but don't work or don't know how to so if any one can help or has ideas that would be great! 1) Solution:Search the names of the...

Hello Quick question: I was wondering if it was possible either via hotkey or some other setting or option so that if I click on a cell the row and column containing that cell are highlighted. I have a lot of information to sift through and I would love if I could click on say A47 and have A...