transfer

  1. I

    Update code for userform source

    Hi, I have a userform which has Comboboxes for which i select an item from the drop down list. Once all the boxes are complete i then click my transfer button to entere it on my worksheet. This is the code on my transfer button. Private Sub CommandButton1_Click() Dim i As Integer Dim...
  2. I

    Slight edit to existing working code

    Hi, The code in use is shown below. This is how it works. I have a listbox with customers names. I select a name & when i press the DateTransferButton todays date then is entered into the cell for this customer at colomn G I believe at present if a value is in the G cell then i see a message...
  3. S

    VBA to Transfer data from one workbook to another

    Hi all, Still learning VBA and this may be a really basic question for all, but I am struggling to find the answer while surfing. Would really appreciate some simple explained help to learn. TASK I want to transfer data from one workbook to another. using a "transfer tool" which i can email...
  4. N

    COUNTIF for a word within a phrase

    I'm trying to count the number of times a word appears within a phrase. Each row lists an action taken by an agent (i.e. Policy: Transfer / Sellers). I'm trying to use COUNTIF to count how many of the row contain a specific word, like "Transfer" but it keeps giving the result as zero. I...
  5. D

    Copy and Paste from one sheet to another or transfer data from one sheet to another.

    All, I'm trying transfer data from one sheet to another. Doesn't seem to be working. Worksheets("Sheet1").Cells(Rows.Count, "F2").End(xlDown).Row.Value = Worksheets("Sheet2").Range("B5").Value Any idea what im missing?:confused:
  6. HomeTek

    Copying Completed Fields and Pasting Into Next Blank Row

    Hi, I'm having a bit of trouble with this, which I thought would be fairly simply. But apparently not simple for me if anyone can help please? I have a worksheet like below... And when I press the macro I want it to transfer the data above to populate another worksheet so it looks like the...
  7. D

    Inquiry

    Good day guys! For example i have a set of data from sheet1 from column 1 to 10 A1 0 B1 0 C1 0 D1 2 E1 34 F1 65 G1 32 H1 23 I1 15 J1 90 How can I transfer it to Sheet 2 and it will: *transfered all values to rows *it will transfer all values starting with the non zero value(in my example it...
  8. M

    ROBOCOPY - Incorporate to excel VBA

    Hi, I am thinking of incorporating the ROBOCOPY with excel since I am doing a lot of file transfers. I just have no idea where to start. I would like to be able to enter a source and destination path into a cell then maybe some radio button or any kind of selection depending on what specific...
  9. I

    Advice for existing working code on userform

    Hi, I believe the code supplied below is what you require. I have a worksheet database where i send out parcels to customers & once parcel is received i like to make a note of the date on my database. I have a drop down list on my userform which looks at the worksheet & loads any customers name...
  10. N

    Double Vlookup Help

    I'm trying to set up a table that has a date, then different expenses on each date. Ultimately I would like to reference expenses on each day for specific expenses. Maybe the last 10 days of "Voids", a double vlookup that could find the date, then the void and return the column value. There...
  11. D

    Transfer multiple Userform Textbox value to cells/columns

    Hi.. I have this code below that transfer my "Textbox1" to "Textbox20" to column A. I have another set of Textboxes ("DataBox1" to "Databox20") that i need to transfer to Column B. can anyone help me on this. Thanks Dim lrow As Long, i As Long lrow = Cells(Rows.Count, "A").End(xlUp).Row +...
  12. J

    Transferring data from one sheet to another

    Hi all, I am currently working on an order form for our warehouse. I have a master sheet (Template) which holds all the current items we stock. When entering the quantity to be ordered on the master sheet, it is transferred to the Order Form. Here is the code used for the transfer of data...
  13. V

    Multiple IF commands

    Hello Freinds, I'm working on a data were in B columns I'm having "Recharge" Or "Transfer". I'm using IF formula to calculate the Transfer commission. If " Recharge" Is there, then the commission should be "0". Can anyone help to get this formula.
  14. I

    Run time error 381 as opposed msgbox message

    Evening, I am using the code supplied below. On my worksheet i have a date transfer button. What shappens is the customers receives his parcel. I open my userform & in the drop down list select that customers name. I then press the date transfer button & todays date is then put in the cell in...
  15. I

    Highlite drop down selection in existing working code

    Good morning, I have a userform which has a drop down list complete with customers names. I use this to then add a date to that customer. This is an example of what i do, I see that the customer has received his parcel so i select his name from the drop down list & then i press my transfer...
  16. I

    Edit to existing working code

    Afternoon, The current working code is supplied below, Basically it allows me to keep certain information about my customers with regards their purchase from me. Currently it works like this. I enter the new customers name in TextBox 2 like example JOHN SMITH "this is his first purchase" I...
  17. A

    code transfer all of data & coordinate from sh1 to sh2

    hi guys i have some datas and coordinates in sheet1 and i have macro buttons to transfer to sheet2 here my code doesn't well work transfer some of data but not all i would in every time to fill data in sheet1 transfer to sheet2 every thing data an coordinate like color Sub...
  18. M

    Transfering Data between Excel Tables of different setup

    I have a table that I need transferred into another format. All the information stays the same but it will have a different logic: rows become columns and vice versa. This is a table with a LOT of data so I can't do it manually. What is the easiest way to do this? I'm thinking a formula that...
  19. S

    Transfer from Excel to HTML Input

    Hey Guys, I'm wonderng if it is possible to transfer data from exel vba to multipe HTML Input boxes? I would like to replicate the HTML Form onto an Excel UserForm which will be used to automatically generate data. I woud then like to have a button_click on the userform to transfer the UserForm...
  20. A

    Problem transfer data of cells from sheet1 to sheet2

    I have problem transfer data of cells from sheet1 to sheet 2 give me the data is not accurate in from sheet1 i hope to help me here the image you can see https://ibb.co/D7dSw5x https://ibb.co/qgjbmqm https://ibb.co/mCwNy2W

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top