copypaste

Hello Experts, I want to copy a range (a1:d6) from Sheet1 (Name changes everytime) to to the same cells (a1:d6) of all other sheets in the workbook (the number of sheets changes everytime). Thanks in advance.:)

Hello! Long time lurker, and I've always been able to find my answers here. But try as I might, I just can't solve this one!!! Basically, I have a sheet in which I need to enter learner details for learners booking onto a course. The sheet doubles as the signing in sheet (so the list can just...

I'm writing code to copy rows and then insert copies of the same rows below. The numer of times it should copy and paste those rows is defined as Unit 1-7. After each for loop, I would like the code to insert a different row that sepeates each block. Please see the code below. The bold italic...

Hello. I hope somebody can help me. I have this piece of code, which takes some values, and copy them into a list (It's a reservation system). How can i rewrite this to get it to paste ONLY VALUES in destination! because some of the elements in the reservation system are auto-calculating...

Hi, What 'm trying to achieve here is for the code to select the first 3cells only (row) not the whole xltoright. how can i make the code to copy the 1st 3 cells in the row and then select A1 and paste the 1st value 2nd value in A5 and 3rd copied value to A6? Thanks for helping Sub Macro1()...

Hi, I have data from B1:B4642 only, if any of the cell contain hyperlink then copy cell (Using all source theme) and paste it col C finding the next empty cell. Thank you for helping! Pedie

Hi, Once i enter date in range ("b2") in sheet2. I want a code to find the date in col b:b in sheet1, corresponding to date is table, if date is found i want the code to select the date, select current region (which will be table), copy it and specialpaste it with all using source theme in...