copy & paste

I am working on a quote tracking program in excel and would like to streamline the quoting process. I have an office form my sales staff can fill in which populates an excel table for me to see the information. Within the table I have formulas to do many things and one is to compile a lot of the...

Hi all, Need an urgent solution to the below please, if possible. It is beyond my VBA capabilities. I have created a new Excel workbook and inserted a macro button name "Import NC Data". What I need the macro VBA code to do it to ask me to select / specify a specific folder (folder and...

Hi all, I got some code that helps copy an excel table and create an email from it. My only problem is that I can't seem to find the way or what part of the code to modify in order to keep the columns width and avoid the table going narrow. Thanks in advance! Below both codes I use: Sub...

Dear all Good day i am having problem on copying data from 3 excel file to 1 master file. i want to copy from source excel file to 1 master file this is my code : Sub CopyData() Dim Fname As String Dim scwbk As Workbook Dim dswbk As Workbook Dim a As Range Dim b As Range...

I named 4 different sections of cells as a range name, specifically sheet 2 a1:a5, a10:a15 and a20:a25. named it "split" I wanted to copy paste into same range on sheet 1 and named it "splittgt" It gets all the way to paste then gives me this error. "This action wont work on multiple...

The worksheet in question is NOT a table. Some of my fields are merged and I am fully aware that I need to unmerge to copy/paste then merge after the code runs. My worksheet contains two sections which are restricted to a set number of rows for data entry. 1) Responsible Party Analytical...

I have a spreadsheet with form control checkboxes next to various cells. I would like a formula where if the checkbox is selected, then it copies a specific cell and pastes it into a range on the same sheet (I4:I15). There will be multiple checkboxes checked so I would need it to copy/paste...

First of all, thank you for reading my post. Second, thanks to all those folks who know wayyyy more than me and are always willing help. Here's the challenge: I have one spreadsheet with 2 sheets. "Schedule_Summary" is pulling certain data from a table via Vlookup in "PPW_MPS_Info" through a...

Looking for some help creating an macro to automate a task. The excel file I am working with contains two (2) tabs: 1) Upload Sheet and 2) Database Sheet. The Database Sheet contains a large list of names (reference column B in example below). We use Column A to select the desired name...

I can't seem to figure out why I can not copy and paste anything in Excel, I've tried repairing Microsoft 365, completely uninstalling and reinstalling, and still the issue persists. https://clipchamp.com/watch/w0lFjpAue0T

Hello everyone, I really thought I could do it but after a morning having fun I decided to ask for help. I have a data tab with some characteristics in the range B32:C43 (on the B column is the characteristic and on C is a "yes or no"). I want to copy the cell B content when the cell C value...

Hi Gurus, Good day! Could you provide your insight on how the macro can paste the data from a worksheet to another with merge cells? Workflow: 1. I have a main data worksheet and files to update. Files to update on this case is same with State provided in Source worksheet. All State data...

Hello all, new to macros here, but this one has me extra stumped. I want to copy two cells (B21 and B23) in Sheet1 and paste the numbers into Sheet2. The catch is the figures being copied need to be pasted into the last empty column in Rows 2 and 3. The copying and pasting isn't so much an...

Hello - I am attempting to copy certain cells from Workbook1 and paste them into the last row of Workbook2. I have tried a few different ways but I keep getting stuck at the same spot. Any help would be appreciated (as I'm sure there's an easier way to do this). It keeps getting hung up when I...

My dear community, I am struggling to write a macro that will do the following steps and I would like to ask for your ideas: I would like the macro loop the same steps for addresses marked as 1,2,3,4,..10 all the way to the highest value in 'Addresses' column A. Step 1. Copy data from...

Morning, I currently have vba to copy a report from one sheet (Rufus Unal) to another (UTM Unal Cash Report), rather than copying the whole report I would ideally like it to only copy data from the Rufus Unal Sheet that isn’t already on the other sheet as currently it just copies all the...

On Sheet 1, I have a table that gets copied onto Sheet 2. Sheet 2 then has the entire table with some additional information that is manually inputted with each row. Currently I have it set up in each column where it is just ='Sheet1!'A1 for every cell. I get my information from Sheet 1 from...

Hello everyone I have a workbook that has several sheets. Each sheet is named 123, & (A,-Z). See the screenshot I provided. This is a workbook that is being used in my place of employment to search Material Safety Data Sheets. What I'm looking for is VBA to copy and paste column C in all...

Can anyone please assist me on this request and here's the link for it: https://stackoverflow.com/q/76588334/13644020

Hi, I have an important process in work which i am trying to simplify, I basically need to copy the data (highlighted yellow) in this sheet below and paste it into a new sheet which gets updated every day (it would be great if it could look at the date in a cell on the new sheet and get the...