automate data extraction

I have a workbook where a lot of employee data is updated monthly, screened for compliance, and reported. Since it is updated monthly the data obviously changes from month to month. However, I want to build a new sheet that tracks the trends from month to month, that is automated when the report...

Hi guys, I am relatively new to Excel so please excuse any errors or stupidity on my part. I have a dataset from which I need to filter out values. The data range is from Column A to Column AA. In columns V to AA I have some vlookups that are returning the value of #N/A. I need the VBA to work...

Hello! I just need some guidance into what I'm supposed to actually be learning/googling. I usually create multiple checklists from an Excel 'template' spreadsheet. However, this is too time consuming and I was hoping I could create a simple Master spreadsheet where I could enter all the data...

Hi I'm not sure if this is possible but I'll explain the situation and if anyone has tips/tricks or advice on how to move forward I would greatly appreciate it: At work we have an excel document where to take meeting minutes and all of this text data is kept in a table. In order to help keep...

Hello- I have a folder with 25 different PDFs that have values of different investments. The PDFs can be grouped into 4 different layouts, meaning 10 are organized the same way but with information specific to that PDF, 9 others organized the same way but with info specific to that PDF, and so...

Dear Experts VBA code required to Export Data from Excel to Access I have a table in excel with 5 columns that I want to export to an access database. The data in excel is per below and all the 5 columns exist with the same heading names in the access database. The table name in the database...

Hi All We hold our data in Salesforce Professional. Every day I have to go through the process (in Salesforce) of exporting .csv reports to Excel 2013 to then manipulate the data. I am presently in the process of automating the Excel part with macros. Can anybody advise whether there is a...

Hi. I am a noob! So, apologies if I have missed a post that explain this, as I am unsure of the language to use to describe it. I have 200 questionnaires in the form of workbooks with several sheets. The data is almost all quantitative, percentages or numbers with two decimal places, but there...