Basically, I need the field names as columns with the field answers as rows in Excel. Is there a way to get the right data pulled? I'd prefer not to use any scripts as this is for my company and our IT is very strict. I've tried using Powerquery in Excel as well, with ...
Update or filter the data shown in a chart:You can update your chart at any time by modifying the data set from which it is pulled. To illustrate this, go to cell B3 and change the football sales for 2022 to 15,000. You will notice that the chart — including the trendline — autom...
Hi, sorry, I am actually manually exporting the file as Excel from QuickBooks. I need to then open the file and save it in ordre for the data to pull correctly. If I don't open the file first, the values pulled are "null", that's the issue. Not a huge problem but would be nic...
I've got several sheets that contain tables with date that I want to be able to pull from into another sheet based on the number of days left. Each sheet is there own topic and the data pulled is the... Daniel_Morales You can try the attached file with macros. In cel...
I've got several sheets that contain tables with date that I want to be able to pull from into another sheet based on the number of days left. Each sheet is there own topic and the data pulled is the... Daniel_Morales You can try the attached file with mac...
Getting a null value when i am importing data from excel column having a different data type. Getting duplicates from source table but actually they are no duplicates on the source table Getting error "Failed to Lock variable [File Full path] for read access with error 0xC0010001. Vairable ...
Close all popups pulled from running a an executable Close Excel com object without saving changes? Close Form cluster name using powershell cmd batch launch powershell script and getting environment variables set by powershell script cmdlet won't accept comma separated usernames given from a varia...
The AftLoad script runs after FDMEE has pulled data from HFM, mapped it and written (loaded) it to a file. The Jython script creates a batch script with parameters that call another batch script and passes the parameters as the variables. ...
Every month i receive an excel file, with sales data for that month. The file (in excel) does'nt have a date column, therefore i've had to add a column [month] manually every time i've received the file. I was wondering if i somehow could extraxt the date from the file...
Solved: Hi guys Every month i receive an excel file, with sales data for that month. The file (in excel) does'nt have a date column, therefore i've