import another excel

Hello helpful people! I am trying to import specific cell data from Workbook1 to Workbook2. This needs to be an on-demand action so a button would be best to simplify matters. The button should be on Workbook2 as Workbook1 will change every time. I have never written code nor even looked at...

I'm new. No excuse. I have a spreadsheet that I've been working on for a while and have this one formula left that I've not been able to solve. I've never used the mini-sheet upload before, but let's see if it works. My workbook consist of several sheets. For this formula, (Column B) I need to...

Hi Demigods, I do not have a specific issue at this time, more just want to gauge your advice... I would like to have two workbooks - one called backend, one called frontend. The backend contains rows of data. The frontend contains the backend data imported into it. Is it possible that if a...

Hello everyone. I've been struggling trying to copy data from a file that I download on a regular bases and paste this data in another workbook. I created a loop in order to select the downloaded file from the folders, after that I try to select the data I need and then paste it in the active...

Hi, I need a function/Macro that allows me to import data from files with a specific file name. More background: I am downloading a large amount of excel files from an webpage containing Agricultural data for different countries (all files have the same structure in terms of rows and columns)...

Mr. Excel, I truly appreciate all the great work you do! I have referenced your website for code many times, because your website is very well done, with excellent questions by people who knowledgeable in VBA I have come across a new issue that I am working through... We use Excel to organize...

Hello there, I have a folder containing 3 files : my Excel file (with my macro), Book1 and Book2. I would like to create a macro to import automatically my two ".xlsx" files (Book1 and Book2) in my Excel file. Data from Book1.xlsx would be placed in Sheet1 and Book2.xlsx in Sheet2. I also want...

Hello! I have made a template of sorts in excel to help organize files for the office. The top of the template spreadsheet has a place for a Name, Employee ID, address, company, Job Title, and Date of Hire. The second half of the template is where I will put elections that employee has made...

hi, I currently have a growing excel sheet. I copy/paste daily information and use it to feed into multiple pivot tables. My concern is that the spreadsheet is growing and constantly causing issues. I have to do a lot just to maintain the spreadsheet. At this moment we cannot import data from...

Hi, Quite a specific question, might even just be a 1 word answer (if it is, hopefully it's "no", as just answering "Yes" won't be that helpful)..... So currently I run 3 reports from 3 different systems that don't talk to each other. Previously, I would take the output from each and combine...

Hello. I am attempting to create an analysis workbook with three tabs. The first would be a variance table using formulas to compute differences between the other two tabs (which would be "Old Data" and "New Data"). My question is, how would I create a command button on "Old Data" to import...

Hello all, I've got an issue where I've imported a table from a different workbook and all the dates that have been imported are showing the number value of the date (even though the original data is formatted to a date) it also won't let me change the format to a date. It says it's a date in...

Hi guys. Please help with this situation. I'm fighting with it from this morning and i'm desperate I have an excel file as said in the title with 110000 fields and 550000 rows. I have eliminated all the potential symbols in the fields that are not compatible with access. When i try to import...

Hi I am a beginner with vba and I am stuck in trying to import another excel workbook with its location being flexible as the file-name will change. This is what i got so far Dim selectFile As String selectFile = Application.GetOpenFilename(FileFilter:="Excel Files, *.xls*" _ ...