copy paste cell value

Hi, I have tasks to do in my school and I need to copy a specific value on different sheets based on what date today is. So for example I have 16 sheets and I just need to get the specific cells value based on what today date is ( March 3, 2023) and so on.. and paste it to another sheets...

Hi guys. I am trying to replace a copy/paste special with setting the value of a range to the values of another, but I can't work it out. I receive no error message, but the values not getting written in to my rgto range This is where I am at the moment: The last few lines are the ones not...

Hello, Currently having some issues when copy/pasting some range of rows. There are some formulas in there that would be populating depending of another table. So in the end there would be some rows populating from such table, and eventually remaining rows without populated values would remain...

Hi, I am new to coding, and a basic code is not working for me. Looking for help Following is my complete code which does other functions and I have added a small code in the end to copy paste a value from cell to other cells based on a condition. Basically, I want to default a value of a cell...

I would appreciate any help with writing a macro that took a 10,000 row spreadsheet and worked some copy/paste magic. I have spreadsheet example with 2 tabs. one is original data download and the second is what it should look like after the macro is run. I basically need the macro to do...

Hello, I have been looking for an answer and I realise all that numerous types of script can be written for each action. I am producing a guestlist for a large event in which people across a network can access and then enter their details. If someone can help me with the script then I would...

I know I am doing I am missing something very basic, but I can not for the life of me figure it out. I am trying to copy cells D3:D43 to another workbook's cells E3:E43. Can somebody tell me what I have wrong here? I get the error message on the last command. Sub Appointments()...

Hi I have a large data base that has duplicate data on several rows - except for a single cell value. I need to copy this one unique cell to the cell after the row below (that has the 'near identical' data). Its not just 'cut and paste to one cell down and one cell across' as sometime there...

I have 2 tables that I use to do VLookup's. One table uses a truncated version of the item name. Is there an easy way to have excel copy the full name and then paste an edited (truncated) version so my 2 tables match?

My first post here (I tried several examples, but nothing seems to work, so I registered here). Here is the story: I have a list of product names and prices in a sheet called MyList. Now, I am building a calculator in another sheet (Calc) which needs to use the data from MyList My Calc sheet...