Hello there
I need to make a excel document where i get live updated data from another excel workbook. im struggling with using the Data -> Get Data -> From File -> From Workbook.
my problem is that it seems like i need to have the first document closed down in order for the second document to...
Hi there,
I'm tracking data for parliaments and would to like to take data from last year's excel sheet and populate new ones for 2021 that has slightly different rows, columns and ordering (so a copy/paste won't work). What the old and the new have in common is: country names and chamber...
Hi
At this time I am seeking info in regards to the possibility of excel being able to do the following...
I presently have clients that utilize a generic worksheet to enter data specific to their staffing process. Once they submit to us, I would like to transfer the information into a...
Hi
I need to write a macro to open a file and transfer data from one file to another; the problem is I will never know the exact source filename. Let me explain.
Data is collected in one program and it is output into a daily .DBF file. The filename is in this format, SB20200531.DBF The problem...
Hey everyone,
I have 3 IDENTICAL workbooks (say WB-A,WB-B,WB-C) with 4 sheets in each workbook (say WB-A1,WB-A2,WB-A3,WB-A4 / WB-B1,WB-B2,WB-B3,WB-B4 / WB-C1,WB-C2,WB-C3,WB-C4). These 3 workbooks are basically reports for 3 different projects, which are updated individually on a monthly basis...
hi
Can anyone help me to transfer data from a password protected workbook to another?
This code is working the problem is even if the password in wba, the excel always asks when I open the workbook.
So I cancel and then I have to runsub manual to get what I want.
Thanks in advance
Nick
Sub...
I've been trying to figure this out for at least ten hours total now, and I have to admit I cannot do it myself. I'm just too new at VBA and too bad at programming.
Ultimate End Goal: to create a table of Authors based on data entered in a primary table, upon entry or update, without duplicates...
I have a form where I fill ListBox(lstSearchResults)
How can I after select one row, transfer data (Client, Name, Surname, Product) into sheet(Vstup) to cells D2,D3,D4,D5?
Can anybody help me, please?
Hi
I need to be able to bring some data from a sheet in one file into a sheet in another file, but have no idea where to start and am hoping someone here may be able to assist. I'll try to explain.
The source data I am after resides in columns P & Z and the sheet is called VDW Place. To find...
Hello Guys,
I want to transpose data with 5 Columns to only 2 and a new row should be created for every column.
Source Data:
<tbody>
Berlin
1000
2000
3000
4000
5000
Dresden
500
300
300
300
300
</tbody>
After the macro, the data should be transferred to this result:
<tbody>
Berlin
1000...
Hi.
I have this VBA code, where i pull data from word and then i transfer other data back to word.
I have this code:
Call findAndReplace(Replace(Round(vbaSheet.Cells(i, "U").Value, 2), ",", "."), "Freight:", 3)
And this code for example takes this from excel "155,40" and returns it to word as...
Hello,
I am looking for some help creating VBA code that will transfer expired rows from the first worksheet - called "Valid Clearances" - to the second worksheet - called "Expired Clearances"
I initially troubleshooted this issue via google, but the codes I found never worked when I tried to...
Private Sub CommandButton1_Click()
'Declare variables
Dim I, LastRow, MLastRow
'Locate LastRow value
LastRow = ActiveSheet.Range("A" & Rows.count).End(xlUp).Row
For I = 2 To LastRow
If Cells(I, 1) > 0 Then
Range(Cells(I, 1), Cells(I, 30)).Select
Selection.Copy
Workbooks.Open...
Hello!
I am a new analyst and I am trying to make a report at my work more accurate and free of human error.
I have one worksheet which is a template (we use this template every day and we save under the current date) before saving we must update this template with the current date's...
I need to cycle through the tabs in an open workbook using their names to open corresponding workbooks (see working code below) and copy data to those tabs. I also need it FIRST to check that the last tab is titled with the current month year. I have two sets of working code but am having a...
Hi all!
I've been researching this for days and cannot seem to find the proper way of doing what I need! I feel like it's pretty simple.....
I have a master sheet where data is entered as such:
<tbody>
Date
Log #
Building
Rep
12/31/16
123456
5
Jane Doe
1/4/17
789012
10
Jane Doe...
Hi there,
I am currently building a spreadsheet for a fantasy football (soccer) game. I've hit a bit of a stumbling block.I have created a simple table which includes players names, clubs, points etc. and a column at the end with a simple drop-down menu that allows you to select a player.
I am...
PLEASE HELP! I will describe this as detailed as possible.
GOAL: To auto-transfer data (criteria based/no blanks) from an online-based Sharepoint file to a separate workbook for analysis
From (Source) File = “LabData.xlsx” located online at http://sharepoint.com/Labs/LabData (made up)
To...
Good afternoon,
I am working on a form containing three listboxes. I have created buttons to be able to freely transfer data from one listbox to another, but I'm stuck at the code. The data that populates the listboxes upon form activation comes from different work sheets in the same workbook...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.