copy paste

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

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!

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Hi everybody I'd like to share my Excel copy-paste / data transformation tool called Pattern Transfer: PatternTransfer.co.uk 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...

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