transfer

  1. 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
  2. K

    Bringing duplicate records of single staff on multiple pages in Excel.

    Hello to everyone I have a multi-page excel book. There are duplicate records on the pages. is it possible to transfer the records of the individual personnel to the new page with the macro?
  3. S

    question of entering array formula in VBA

    Hello all, Does anyone have any idea what's wrong here? I was trying to transfer worksheet array formula into VBA. I wanted to use quartiles to draw box plot. I recorded a macro and press F2 then "Ctrl+Shift + Enter"in the worksheet cells to transfer the worksheet formula into VBA. But it says...
  4. M

    Data transfer one sheet through button another sheet

    Hi all, kindly help me to solve this. i am working Purchase order data transfer to another sheet with button. kindly tell me coding or you any other option to transfer this button. it is duplicate thread...
  5. G

    transfer data from invoice to worksheet with vba

    Hi everyone, Please how do i transfer data from invoice template to worksheet table automatically with vba
  6. I

    Transfer Specific Column From ListBox Userform

    Hello everyone Please help me I use this code to transfer in cell D1/E1/F1 the selected values from listbox userform. With this code i can transfer all columns from selected row Which is vba code to transfer in cell D1/E1 only the first and third columns of selected row from listbox. (i want...
  7. R

    Transfer data from userform textbox to sheet

    On a userform when I transfer a standard textbox to a cell it transfers ok (Range("C3").Value = TextBox1) However if I want the text box to be wrapped, i.e. change Multiline to True and EnterKeyBehaviour to True it transfers the data differently with speechmarks Any ideas??
  8. D

    VBA code to copy to a specific sheet

    I am trying to make some way to transfer specific entries to a monthly sheet, that is not depending on the date. I want to select the row then choose a month from a combo, txtDirectMonth and type a year into txtDirectYear then press a button. I then want the row to transfer to the relevant...
  9. P

    Transfer multible sheets into the existing sheet named "Results"

    Hi all, i would like to create a VBA code so that to run through a workbook and transfer all Sheets' data (Sheet1, Sheet2 e.t.c.) into the first one, on the left which is named "Results" and it already exists. Therefore that The data of each Sheet, should be placed into "Results", below each...
  10. P

    index formula

    Hi Guys, i've got the below forumula working on google sheets, just to need get it to work on excel if possible https://docs.google.com/spreadsheets/d/11PW7jopnfnlqsgEMlTz_UxXzlJczV6q7PFHqxKKIxU8/edit#gid=0 below is the formula for sheets, how would you transfer this into excel...
  11. J

    Transfer data from userform textbox to table (multiline)?

    Hi, I have a userform which has a multi line text box for data input (textbox1) And a single line textbox (textbox2) How would I transfer the text from textbox1 to columnA (after last row of data) and textbox to ColumnB Example: Last row of table data is 17 Textbox 1 has 6 lines so should...
  12. B

    Sum values between recurring text

    Hi, Just looking to see if there is a method to sum values in a range between recurring words in a separate column. I am trying to use one column for the formula in the total column. So far "=IFERROR(IF($B4*$C4=0,0,$B4*$C4),0)" is in column D with some conditional formatting. I would like to...
  13. P

    transfer selected data by colour and move to another sheet

    Hi, good morning. Hope you are all well? please can you help me I have the code below where I am trying to transfer data from sheet1 to sheet2, but it has to be data that ihas coloured rows in red and green for example, and then to transfer the whole row from A - V. then to shift cells up and...
  14. E

    Help with putting two formulas to one cell.

    I'm trying to create a budgeting plan and my husband has to transfer money to my account from his own to cover a bill that is pulled from my end. If cells N5:N24 are added together based on whether cells K5:K24 are "K" or "J". I want to add or subtract a cell From N5:N24 based on my husband "J"...
  15. D

    Fast method to transfer values without using clipboard?

    I am teaching myself VBA and I have been running a certain task via Copy and PasteSpecial Paste:=xlPasteValues and it completes the macro within 7 seconds. The task is to move the values to the left by one column. I've recently read the clipboard should be avoided when possible thus I used an...
  16. R

    Formula not working

    Hi I am using below formula in a cell, F4 =(IF(AND(B4="MONEY TRANSFER",E4="1"),SUMIFS($R$4:$R$8,$P$4:$P$8,"<="&D4,$Q$4:$Q$8,">="&D4),IF(AND(B4="MONEY TRANSFER",E4="11"),SUMIFS($R$4:$R$8,$P$4:$P$8,"<="&D4,$Q$4:$Q$8,">="&D4)+3.5,IF(AND(B4="MONEY...
  17. G

    Timing of events on different levels

    Background is that our IT has allowed us non IT types to get to some SQL data which I get with a Data connection in Excel. I would love to pipe it straight into MS Access but I imagine even to humbly request that would create a dread sense of panic amongst them and I would subsequently live in...
  18. R

    Need profit calculation formula

    Hi good afternoon. I am doing money transfer business and i need to entry every transactions in excel to calculate the profit. But it takes a long time and need your help to make it better. <tbody> DATE TDS TRANSFER AMOUNT PROFIT 01/12/2018 2 5020 73 </tbody>...
  19. M

    Transfer Data from Different Cells and Copy to Other Sheet

    Hi! :) I've built a basic form (not using the form function, just plain cells) in Excel, which users will input data. There are about 25 random individual cells for data entry, such as Name, School, Date, etc. In another sheet, I have built the frame for a small Database (e.g. A2 is "Name", B2...
  20. F

    Transfer Dax Formula into PowerQuery M-Language so I can exclude from Power Desktop

    Hi all, I have the following dax code which i want to transfer to power query so i can exclude certain rows before they get to Power Bi desktop: FilterMostRecentSurvey = IF ( SurveyData[Report date] = CALCULATE ( LASTDATE ( SurveyData[Report date] ), FILTER...

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 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.
Go back
Back
Top