transfer data

  1. B

    Moving data from a generic worksheet to a generic workbook

    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...
  2. H

    Copy Data From Changing Name File

    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...
  3. M

    Transfer and update data from various workbooks into one

    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...
  4. F

    Transfer from protected Workbook to another workbook

    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...
  5. L

    Notepad File to Excel Column

    I would transfer two information (filename and file content)from multiple notepad to "column excel" as attached Appreciate someone helping. thanks
  6. K

    VBA to copy data from one cell, based on data in another cell (formula output), and paste at the end of a table in another sheet

    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...
  7. MinoMacro

    How to get selected data from ListBox into scecific Excel Sheet

    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?
  8. H

    Collect Data From One Sheet Into Another

    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...
  9. B

    Transpose Columns To Rows And Insert New Rows To Fill Down Data with VBA

    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...
  10. M

    Keeping trailing zero's when transferring from excel to word VBA

    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...
  11. M

    Auto transferring expired rows to 2nd worksheet

    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...
  12. M

    Transferring & Append New Data from one Workbook to Another Workbook (What's wrong with my code)

    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...
  13. J

    Extreme Beginner (Macros) - Need Macro with Date Form to transfer data

    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...
  14. C

    Combine my Macros not going well.

    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...
  15. R

    Auto Transfer Data from Master Sheet to Several other Worksheets

    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...
  16. M

    Helped needed with formula moving data from one place to another

    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...
  17. N

    VBA to Transfer (Certain) Data from One Workbook to Another

    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...
  18. B

    Moving Items Between ListBoxes

    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...
  19. A

    Transfer data from one column to another based on condition

    I am looking for a way to transfer the data using a formula to accomplish this: <!--StartFragment--> <colgroup><col width="65" span="3" style="width:65pt"> </colgroup><tbody> A B C First x First Second Third Third x Fourth Fourth x Fifth...
  20. C

    multiple data sheets into one sheet - data sheets will have different amounts of info

    Hi all, New here so first of all hello to everyone. I have popped in here to see common problems and answers before so thank for you help there. But, now I have a good one for you all and I hope you can help me. I have a report that I want to run every 3 months for my staff. I have a template...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top