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
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?
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...
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...
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...
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??
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...
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...
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...
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...
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...
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...
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"...
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...
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...
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...
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>...
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...
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 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.