import data by vba

Hi Each week my company receives an exported orders spreadsheet from SAP. Basically I want to run a formula that will check if data exists in the existing orders spreadsheet, but i need the entire row to match, if one cell changes I would like it to change in the existing data. If data does not...

Hi all, So basically I am trying to create a standardized tool that I can give to customers, and it will return graphs and values for a number of metrics. I want the sheet to have a button that says something along the lines of "Add data here" and they can add their data from another workbook...

Can someone please point me in the right direction. I have dozens of workbooks in a local folder where I need to import a specific worksheet "General Ledger" into the current workbook. The code I wrote does open the workbooks but seems to break when it gets to "total" even though when checking...

Hey! I really nob in VBA and I feel that this is something fairly easy to do but I can't find an answer on my search. I have around 20 files from different teams, each one with different sheets but they all have exactly the same layout. I need to import data from one sheet from each file to...

Hi, Hope someone can help me with this problem that I can't figure out. I have a database(accdb) table with 4 fields, ID, First Name, Last Name, Start Date and I have an Excel spreadsheet that has 3 columns, IDEMP, Full Name, Start Date. I'm trying to create a macro in Excel to import the...

Evening, I am trying to copy the data from One excel document to another but am having a difficult time with it. One workbook is permanently open, this is the one that needs to import the data. (Main) The other, is closed in a folder, this is the one that I need to copy the data from. (Source)...

Hello! I'm trying to import all worksheets from all files stored a folder named "Path Folder" into an active workbook. Example I have 3 workbooks named Project 1, Project 2 and Project 3 in the folder named "Path Folder" and each workbook contains two sheets. I need to pull all 6 sheets into...

I have successfully imported a table no problems here...now the tricky part. Each row contains a hyperlink to a project page, which in turn has a hyperlink to a project - organizations page. Coincidently, on the project - organizations page there is a next button so it is also easy to jump from...

Hello, I have the below code that works on selecting individual files in a folder and actions a column index and match. Can anyone help amending the code so it can action all files instead of selecting one file one at a time. [code] Sub PDB_Import() Dim vFile As Variant Dim...

Is it possible to write a macro that would action all files in a certain folder with the below code? The folder name and location will always stay the same but the name of the files within and the amount of files may change. The macro would open them all, and run the below piece of code...

Hello, I want to pull some financial data from a website. Google Sheets has a fantastic function for grabbing data from tables. In my example, I want to pull the balance sheet for a specific company. Here is a link to the Google Sheets' example Is there an Excel equivalent? I tried getting...

Hi, I'm quite new to using VBA, and already very enthusiastic! I am trying to create a macro where I am able import sheets from other workbooks automatically into my workbook. I have managed to do so with the following macro: Sub import() Dim wbCopy As Workbook Dim wsCopy As Worksheet...

I have multiple MDB's files in a Windows folder named 'Results' MDB1.MDB , MDB2.MDB , MDB3.MDB .... MDBx These are Quotation results from vendors. Each MDB has the same Query 'Q_Total_RFQ'. The query has three columns: "RFQ" , "Vendor" , "Total" Now what I need is to run a script or macro...

Hello All. First Time here and very limited with VBA code. I am an administrator for a Police Department and I use excel spreadsheets to keep statistics of officer's daily activities. So I made up a spreadsheet called a patrol log that they each file out electronically and save to a folder on...

Brief & descriptive as possible. I have formatted the naming of inspection photos in a manner in which contains details to be populated within a spreadsheet pertaining to their location. I'm trying to use a set of code that takes segments of the file name, transfers them into their respective...

Hello, I am using a loop to copy/ paste data from 0190.csv file (A column) to client (field 3, 30) in order to get an internal reference appearing afterwards in client 3, 14 field. My aim is to copy-paste data from client field 3, 14 to a new excel file. I am able to move my cursor to that...

Hi All, I'm a newbie with VB & macros, i've been recording a macro manually and tried to edit it with bits and pieces that i found on several forums. It does work to a certain extent but i'm hitting several issues. i have a workbook with 3 sheets "NECA ASR Pivot Table", "Install Compliance...

Hi, I am trying to create a macro to automatically import several Excel reports into my data base in Access. The names have some similarities (I use this similarities for another macro I use that depending on the file name it gives the proper format to the file) for example dependig if the...

I am new to excel VBA. I have a requirement where I have to copy table values from sql server 2005 to an excel worksheet. I have googled and written a code for the above requirement (listed below). In this excel sheet there are fixed set of rows which displays legends and dates. These rows...

I m new to macro and I need to copy the data from row 26:27, 36:37, 46:47 cells value which are converted into E9:F39, P9:Q39, AA9:AB39, 12 columns in the other workbook. How can I do if I want to import the data directly instead of making a copy of the report inside of my workbook by using...