macro - copy/paste

Hi all, I'm somewhat new to macros in Excel and I've been experimenting with a couple of macros but can't quite get what I need. I have three columns (AF, AG, AH) in an Excel sheet that I need to limit with a certain amount of characters (I can't use formulas as the data will be copy pasted)...

I have a column at Q in sheet OC where values are there Q3 to Q24. These values are fetched in real time. It changes every millisecond. I have raw data in different sheet which changes every millisecond. I use vlookup function to format and give meaning to it in OC sheet in Q column. I have...

Hello, I am trying to trying to create a Macro to move information from my 'Export' file to my 'Yearly' file based off the worksheet name in the Yearly file. In the 1st screenshot below, I need to copy all rows and only column A to P, and then move these rows to the matching worksheets in...

Hello guys! Hope u are good! Could someone please help me with this code I'm trying to edit an reach my goal? Goal: copy rows from a Sheet1 to a Sheet2, that meet a criteria, with a Date and time record! for example, all rows that have yellow as text in the colum G of sheet one, after I click...

Hi, Good day. I have a concern I hope anyone can help me. I have a list of files from d2:d4 on a worksheet. I need a macro that can open one at a time copy the latest date on a specific column and sheet tab and paste it to another worksheets, then close it, then open the next, etc. On Column D...

Hello fellow excel users, I have 5 spreadsheets each with 48 columns. Based on the values entered in 'column B' I would like to copy those particular rows but not all the columns to a separate 'destination' sheet. Also, checking across the rest of the spreadsheets. Please see below to the...

Hi Gurus, Do you have any thoughts on how to code this. I have a binary file with data ranging to 1 million lines. I am planning to copy the data in xlxs version. The header to be use is same with what's in the binary for all sheets. Example: Open Binary File that contains 1.05 Million lines...

Hi Guys, Happy New year! I found below code however, it seems like only column A of each sheet is being copied on the combined Sheet. Is it possible to adjust the range and copy everything except Row 1 for each sheet? = = = = = Sub Combine_Sheets() Dim startRow, startCol, LastRow...

Hello Gurus, Hope you are doing well despite the pandemic. I was wondering if you have any idea on how to code this: 1. I have a worksheet with 5 tabs or more (may vary). The headers are same (see below): Number Name Sales Div Data Note 1 Sam SA 100 2 Amy FA 90 2. I want to create...

Hello, I am very new to using VBA and don't really understand much at the minute. I am trying to get it where when the word "Yes" is selected in both drop down boxes in columns V & W, that row is then cut and pasted into the worksheet "Delivered". I then obviously want it to paste to the next...

Hello All, The purpose of the macro I am working on is to batch produce pdf customs documents, by copying the values from the variable workbook (it changes name every time I take a fresh download from the database), pasting them into the fixed workbook where the relevant customs info is...

Hello Gurus, Good day! Could you possibly help me amend the codes I found below: Basically, I am trying to create a PPT Template for my report - the charts, table format and tab names in excel are same. Is there any way to copy the format in excel (as seen in the excel print preview) on the...

Hi, I'm trying to figure something out with a macro that I'm working on. I'm not very experienced with macros but I'm figuring it out as I go, and what I want to accomplish is working EXCEPT when the source table doesn't have data for a particular filter. Here are the details (with fictional...

Hi Gurus, Could possibly help me formulate the codes so I can get the results like the Clean Sheet? I just need to get the data per account per month in descending order and will exclude those accounts with zero shares. Raw sheet <tbody> Account Name Note Mar-19 Feb-19 Jan-19 001...

Hi all! I'm super new to macros/vba and am working on a project for work that requires me to import csvs from a folder into a specific workbook. Each csv will need to go into a new sheet of this same workbook. I read around on the site to get the code I need to pull this off, but for some...

Hello Team, need to automate the process where in i am currently copy paste the data from one file to another file. Needed in macro. 1. Select the file that needs to copied (Source File). 2. Copy the all the cells, which have data. 3. Open the Destination File, last + 1 row & paste the...

Hey guys so im struggling with making a macro: To start; i get inventory lists that don't have my data on it and have to go copy columns from multiple tabs. I was creating the macro below but the problem am having is: How can i make this work on any 2 workbooks i have (ex: this one is copying...

I volunteer for my local scout group and wish to create a report that shows which badges have been completed, which are in progress and which have not been started. This is to make building a program easier as we can see what badges to work around. Currently we use a system that allows us to...

Hi there Could you please help me here I need to merge particular sheet "Consolidated data" from the different work book saved in the same folder to another work book without formulas. Save as values.

Hi Excel Gurus, I'm working on an macro project and almost done. I'm just having a problem on this: I have 2 excel sheet, one is working file and the other is database. What the macro needs to do is to check the cell with blank category (in working file) and add below column data in the...