help copy and paste

Hi all, 2 questions: 1) I have the following setup: I add new files quarterly to my excel file, so Q1 2021, Q2 2021, Q3 2021, Q4 2021, Q1 2022, Q2 2022 etc. Right now I only have one for each year, but I plan to add many more going forward for 2022- Does anybody have a way in which I can...

I have a report which I have to update from time to time. The combination (Concat) of the values from two columns is unique, so I have a "code" which identifies the row. So, for the example: Sheet 1 has 1000 rows, Sheet 2 has 1200 (The previous 1000 are included in this) I want to copy over to...

Hey guys, I currently have a large list of data, but to simplify, here's a simple example: I currently wrote cell C5 as = J5 I then pulled it through the green box as you see in the photo to the right and got A, B, C, D and E and pulled it down and got 1, 2, 3, 4, 5 However, I want it to...

I am creating a break calculator which will help user to keep a track of his login hours and break time. I have already created a the excel file Please find below the format. <colgroup><col><col><col><col></colgroup><tbody> DATE 08/01/2018 Login Time 09:30:00 Logout Time...

I am brand new to anything to do with Excel programming via VBA. My issue sounds simple but I don't know how to fix it. It is for my job and I feel there is an easier way to do this. I have a workbook that has 177,000 records. The example below doesn't show all the columns on the original and...

Hi everyone, I'm not an expert at VBA and normally use codes written by others online/ in this forum. I have the following macro for my workbook and I will execute this every time I paste new data into my workbook. The problem is, the data involved is big and can be up to 90000+ rows. The file...

Hi all, I need help! I have two columns in sheet 2, "Cust Name" in "A" and "Account Number" in "B". I need to somehow get a macro that will copy both cells of this data and paste them into "B1" and "B2" on sheet1, convert the relevant information to PDF (I already have this part of code) and...

Hey Mr. Excel I have this Code seen below. The point of the macro is to past data from my source sheet to sheets with matching names with some cell values. I have the following sheet setup <tbody> R (Sheet names) S T U V W 5 Overview 2014-4 1 1 6 9 17 6 Overview 2015-1 6 0 3 12 21 7...

Hello, its my first time posting on here so sorry if i am a bit slow. A bit of back round, Im looking to create a reporting framework within excel using data exported from my project management software. The exporting of the data is easy as there is a funtion to do this within the application...

I am creating a sheet that will provide a number of rows based on how many rows the user has. I have a row as a template. Example <tbody> # Server ID Memory CPU Location Brand 1 123 12 2 dallas HP </tbody> Upon entering the sheet you have 1 row to input your information. But if you have...