1. K

    Transposing cell contents from one sheet into another sheet with different order/format

    Hi! First time poster, and absolute amateur at Excel ? I've been trying to work this out for a while but I really don't know where to begin, so apologies if this has been asked in other terms. I need help transposing the contents of one sheet into another sheet where the columns and rows are...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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:
  7. 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...
  8. D


    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...
  9. 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...
  10. 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...
  11. 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...
  12. 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 +...
  13. 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...
  14. 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.
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

We've detected that you are using an adblocker.

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
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 "".
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.
Go back