copy & paste cell

Hello, I have a command button that, when pressed, will copy values(only) from certain cells on sheet1 and paste to certain columns on sheet2, but I'm having trouble with coding the macro. Data on sheet1 will change, but sheet2 is a log, so will need the macro to paste into next blank row in...

HI I need to copy the last value in the column every month and copy paste it into another document which shows the KPI for the current month. So if you look up the picture i need all the values from mar2021 to be copied this month and apr2021 next month. Is it possible to make some kind of VBA...

This might be a simple problem and I've been scouring the internet, but I haven't quite found the solution yet. I have two sheets, "Master Parts List" is my master list with column B having the line number. What I want to do is manually enter the line number into column B in "Template" and have...

Hello! I Have been trying to find a create way to copy and paste values using VBA, and while it does work perfectly, As I add more cells to my list, the VBA code gets longer and longer. Anyone have any suggestion for how I can consolidate this code? There are multiple other pieces, but they...

Hi, Please I am new to VBA. I have two worksheets. One on my laptop (and workmates. clones) and the other on office 365 Onedrive. when my colleagues fill their respective workbooks each on their systems and click a submit button, the data in the selected range is pasted in the Onedrive...

Hi all, I am not able to write a vba code for a specific action I would like to do in excel. I attach two screenshots to explain myself better with an example. Screenshot_1: I want to write text "Level_1" in column A, until in column B the text "Level_2" is found. And then, do the same but...

I have two workbooks for my code, one is a database (The "Changes" sheet in my example) and the other is an input sheet "(Codename "Sheet1" as my code is being written inside this workbook where Sheet1 is). I am trying to have the code check if the value of certain cells in column "K' of Sheet 1...

Hi there, I'd like help creating a macro that allows me to essentially copy and paste information from one worksheet to another based on criteria that will save a great amount of time were it done manually. In the main worksheet I have a column labelled 'Reference' and a column labelled...

Hello! I have Googled and searched the forum here, but I haven't been able to find the exact solution I'm looking for. The context of this request is that I'm doing a database update. The source of the records includes addresses, some of which have firm names in them, some of which do not. Our...

The export data I have has Employee name as first row, then one to many rows of data, depending on the employee's activity. I need to move the employee name down to the row of data that has the totals. Each month the row counts will differ. For example, this month I want to move A1 to A23, A24...

Hi. I have a table with a column A containing filled cells and empty cells. I would like to create a VBA that copies the filled cells to the empty cells below, and when a new cell value occures, this will be copied to the next cells below etc. until there are no more values in column B. Would...

Hello, I am in need of a code to create and save 93 excel client reports and also insert client names and totals into the report (specific cells). I currently have an excel document that is the template report and another document that lists client names and total amounts. I'm hoping there is...

I hope you can help me with on requirement, I have 10 columns data in Sheet1 and during my working, I can change any data in these columns...but usually, these changes anywhere in the row...same data in Sheet2 and whatever changes to in sheet1 should automatically replace the values in Sheet2...

Hello everyone. I've been struggling trying to copy data from a file that I download on a regular bases and paste this data in another workbook. I created a loop in order to select the downloaded file from the folders, after that I try to select the data I need and then paste it in the active...

Hi I am searching for a VBA that will perform to copy the last cell data in a column "A" and paste the same above all the cells in that same column "A" in that same worksheet. Kindly help. I have provided a format here. I need to do this operation for 100 + files . So kindly provide some...

Hi, i am searching for solution but not getting exactly what i am looking for, i want to copy specific columns from one workbook to specific cells in another workbook, and also want to rename workbook and sheet automatically by getting today's name as workbook name? copying column from one...

Dear Sir or Madam, I am looking for a VBA Excel Makro with the following action: I have an excel workbook with many sheets. They are all set-up the same way. I need to copy&Past always the last row within a sheet with the formula and copy&Past thereafter the row above with Value within the same...

Good Evening All, I am creating a project board which has a master dashboard sheet. The idea is that each individual project has its own sheet in the workbook and these are assigned a project number. Then in a weekly meeting I plan to pull together headline information from the individual...

Hi. I want to copy certain cells from a row and paste them in the corresponding row numbers, but in another column. For example, I want to copy cells A1, A7, A28, A2000 and paste them in D1, D7, D28, D2000. When I select cells A1, A7, A28, A2000 and paste them at D1, cells paste adjacently...

I have a spreadsheet which has 10 worksheets, starting with the third worksheet and all those which follow I need to evaluate the data in column K to see if it contains the following: Approved CTO or Approved-STM If column K contains either of these I need to look at the cell in column L and...