copy paste

  1. A

    Copy Paste on TextBox based on TODAY Date

    Hi Everyone, I just want to ask for a help regarding my problem on VBA Macro. So I have 3 sheets which contains Date and Name. Now, I need to display the Name of the person on a TextBox vertically based on what date today automatically once I run the macro. Ex. The Date today is March 11...
  2. F

    VBA Macro : How to copy specific cells on multiple sheets based on TODAY() date?

    Hi everyone, Asking for assistance. Can anyone help me? I want to copy specific cells using VBA Macro based on TODAY() date. I have 10 worksheet and each worksheet have 2 column, 1 for Date and 1 for DataToPull. I want to pull the data based on what today date. Can anyone help me? Thanks!
  3. D

    Trying to make a form that will auto update values on different sheet

    I'm trying to out do myself, I have a basic form built out with drop downs and blanks. So far i have formulas in place that will find an "Available" ip by using xlookup, and i also have an xlook up to find the row, column and sheet name, i have a cell formulated to show a complete location (ex...
  4. G

    copy and paste a row but not the entire row just between A:J

    Hello, I'm trying to copy and paste row value, by knowing if there is data or not, actually i'm using this code : Sheets("Data_Sheet").Range("A" & i).EntireRow.Copy Destination:=Sheets("Data_transfert").Range("A" & Rows.Count).End(xlUp).Offset(1) The i variable here is for the condition...
  5. G

    Select and copy Multiple Column at the same time and past.

    Hello, I need some help, I want to know if it's possible to select mutiple columns from one row until down : for exemple select A5, B5, C5 until down and copy to paste it on a other sheet. For the moment I use this type of code which move between sheets column by column 🤕 : Public...
  6. D

    Copy as formula paste as formula

    Hello I have two workbooks one in which i wish to copy from and the other i wish to paste into. My source workbook some cells have formulas but some have values and i would like to paste as what they are in a tare workbook but the same way So if source cell copying from is a formula then paste...
  7. Jyggalag

    Have formula data appear as text, maybe VBA solution?

    Hi all! I currently have this setup, please note that I have hidden all the nonrelevant columns however: The formula I use is this (thank you @RoryA !) =IFERROR(INDEX(INDIRECT("'"&H504&"'!$U$3:$U$73"),MATCH(1...
  8. D

    run time error 1004 cant do this to merge cells

    Hello, i am getting a run time error we cant do this to merged cells. e29 is merged so using columns E and F and the then what the code is doing is pasting the formula into that cells. Then trying to copy the formula paste it into the cells basically repasting it into e29 when "I" is one then...
  9. T

    VBA copy/paste range based on two dropdowns

    I have 2 dropdowns and would like to copy/paste different ranges based on selected values from the dropdowns (I know how to copy/paste but not based on dropdowns). First dropdown values: -BD -AO -LM Second dropdown values: -UFH -PEX -MLC Ranges: BD UFH = Sheet10 B2:C10 BD PEX = Sheet10 D2:E10...
  10. I

    VBA Loop to go through all sheets. Then Copy a range and Paste it to Main sheet

    Hi Good People. I have an excel workbook with 5 different work sheets. First work sheet is the Master sheet and others are customer data sheets . I want a VBA loop to go through all 4 customer data sheets >> then copy a specific range in each individual sheets >> paste it to master sheet...
  11. Jyggalag

    Create macro that copy paste's data

    Hi all, I am having a huge issue at the moment with some macros i created (through record macro). Basically, I have this excel sheet: I tried to record some macro's, where once I press unfreeze, they post this formula: =IF(ISBLANK(B9),"",TODAY()) for the left one...
  12. Jyggalag

    Power Query question (never used before!)

    Hi all, I am considering to use power query to get data for my pivot table. However, I am EXTREMELY new to both pivot tables and power query. I want to import data into this pivot table (not using power query below): I have the source data saved here: So questionnaire data file 1 is week...
  13. E

    EXCEL VBA or Formula: Split sets £ enteries based on criteria amount or close to it

    Hello all, I'm not sure is this is possible, everything I have looked at seems like it needs to be exact amount. I'm hoping someone can help. Please see image attached. In column B is the list of amounts I want to seperate into C D E F G columns. The total of £189,733.00 is divide by K6...
  14. H

    Copy/Paste Columns from one table in a sheet to another table in another sheet

    This is Table3 in the Sheet Receipt. The first two columns are needed to be copied and their values are to be pasted in... Table9 in Sheet IndividualProfitLoss. Now Table9 is cleared by a code in VBA which is the following : Private Sub CommandButton2_Click() 'ActiveX button's click event...
  15. P

    Copy data from cell range from previous day

    Hi all, So I am with a small challenge today. I have been working in some file I am not figuring out hot to solve this. So my problem: I have a Monthly Excel file, with some sheets. This sheets names (all days in the month) are the dates, as example: 01.01.2021, 02.01,2021.... etc... What...
  16. J

    Auto copy rows from one sheet to another based on sheet names and cell values

    Private Sub CommandButton1_Click() Dim ws As Worksheet Dim ws2 As Worksheet Dim lastrow As Long Dim lastrow2 As Long Dim rownum As Long Dim ws2name As String Set ws = Sheets("RAW DATA") lastrow = ws.Cells(ws.Rows.Count, "E").End(xlUp).Row For rownum = 2 To lastrow Select Case...
  17. J

    Excel macro copy from a single sheet to different sheet

    I am using the below code to copy data from a sheet to different sheets if the sheet name matches with text of column E Sub CopyToSheets() Dim ws As Worksheet Dim ws2 As Worksheet Dim lastrow As Long Dim lastrow2 As Long Dim rownum As Long Dim ws2name As String Set ws = Sheets("RAW DATA")...
  18. T

    Googlesheet - How to skip empty cell in macro loop and continue filled cell?

    Hi, would greatly appreciate if anyone is able to help! I am working on editing a macro that involves vlookup copy/paste data from Worksheet A (IB) to Worksheet B (Inbound POs). However, it copies empty cell in Worksheet A and overwrites the filled cell in Worksheet B which i do not want...
  19. B

    Pattern Transfer: Excel copy-paste tool, for data transformation

    Hi everybody I'd like to share my Excel copy-paste / data transformation tool called Pattern Transfer: The tool allows you to configure source and destination data "patterns" so that you can transform the data structure of many records, quickly and accurately. There's a...
  20. A

    Change size when is pasting

    I'm trying to copy info from one file and paste to another file, but when it pastes, it changes the font size. I'm still learning VBA so I'm probably missing a something... ''' Sub Sites() Application.ScreenUpdating = False Dim InputFile As Workbook Dim OutputFile As Workbook...

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