Change pivot table to values but keep formatting - Excel Help Forum
Nov 21, 2016 · The pivot table is unlinked, but if you use Excel 2007 or Excel 2010, the fancy pivot table style formatting is gone: To get the formatting back, you need to perform two steps: …
Hard code to current date - Excel Help Forum
Dec 29, 2019 · I manually enter data into a dashboard from a number of different apps. I then enter the data using copy and paste into a summary sheet on a daily basis. I am trying to hard …
How to hardcode a concatenate formula into a cell - Excel Help …
Jan 22, 2016 · Hi, I'm an experienced Excel user, but only getting into the VBA side of things. I want to automate some processes in an old spreadsheet to save time and control data entry. …
Adding a hard coded time (hh:mm) to the end of a DATE formula …
Jun 16, 2015 · Adding a hard coded time (hh:mm) to the end of a DATE formula within the same cell Hello EXCEL Gurus. I need to add a hardcoded TIME (military) to the end of a DATE …
Excel formula randomly changes to hard-code number - Excel …
Feb 14, 2005 · I am having an issue with an Excel model that was orginally written by some of my predecessors at work. I do not know the complete history of the file, but it would be extremely …
Creating a Dynamic File Path Rather Than a Hard Coded One
Jun 23, 2020 · Hi All, I'm trying to create a dynamic path for saving .pdf files, currently I'm limited to the hard coded file destination of - C:\Quotes\ - which quickly becomes a hot mess. Ideally …
how do I hard code a variable range for a pivot table in vba?
Jun 29, 2005 · > seem to be more picky than some other code. And honestly I dont write much of > the code myself but know where the key fields I need to change are. Here is > my current …
Changing Year Flag for Fiscal Year starting July - Excel Help Forum
Mar 20, 2017 · Our Fiscal Year starts every July. Any fixes to hard code Excel to recognize July as the "first" month going forward in Pivots? It always starts in January and it messes up my …
Using dynamic file path instead of hard-coded - Excel Help Forum
Aug 20, 2018 · I would like to have cell A2 in worksheet COMP (current data in that cell is 'C:\Users\Melly\Desktop\Test\Drawing Register.xlsx') in the VBA code to replace the hard …
Hard code path to refresh data from a csv file - Excel Help Forum
Jun 3, 2009 · I made this little macro to refresh data on a protected sheet. All I want to do is hard code the "pathfile" into this macro so that the user isn't asked to select the file every time the …