Excel Geniuses- I need a macro the will convert a model with all USD to show it in British Pounds, and then back easily. Anyone have experience with this?
Looking for some good templates for venture planning (start-up financials). Any you would recommend?
Trying to make a stickie note macro in PowerPoint. Anyone know how to select the textbox and move cursor to the end using a PowerPoint macro?
Each country has multiple txns. Some complete, some not. What formula should I use to say if Indonesia has ANY “not complete” then show me the term “not done”. Tried IF(Index Match) but only (cont.)
Having an issue in a pivot table. I had an export pulled from Salesforce and when I add the “modified date” column the format is changing from 3/31/20 to: Year and Quarter (neither are fields in...
Hi All! I would like to learn macros in excel. Does anyone have best YouTube or LinkedIn learning suggestions? Or any other free platforms?
I’m building an account mapping model and want to prevent the user from inserting a value into different tagging columns. I.e. an account shouldn’t be tagged in column E and columns G/H. Anyone know..
I may be late to the party but i absolutely LOVE that Excel now has a “Yes to all” option when you get that annoying notification of a tab already having the name of the tab you’re trying to copy.
If a cell in Column F equals Y, I want the entire row to be deleted and moved to sheet titled Paid Invoices. What’s the macro I should use? Googled and still don’t understand. Thanks!
Noob here:( Lead wants me to limit values in 5 columns - achieved Now she wants me to implement - If 1st column is filled and others' are empty, raise an error. Tried ISBLANK but it removes drop-down
So I built model that uses some VBA functions, but my boss insists on using a Mac and some of the functionality breaks when he tries to use the file. Does literally anyone else in finance use a Mac?
Does anyone else have this issue that popped up? When I hit Alt + N it switches to the insert tab but doesn't allow me to continue the shortcut
Why when I refresh a query, the table where the query is loaded to just gets duplicate rows? Same with the pivot table that feeds off of that query?
I took up a new job at a tech company based out of Silicon Valley and my boss has been pushing hard for me to use Smartsheets but I hate it. I switch to excel whenever I can. Smartsheet vs Excel?
Has anyone ever installed / used kutools? Every time I google excel questions the kutools help articles whisper sweet nothings to me..