special paste

I want to copy three columns in Excel: B-E-G into another sheet so that they will be paste in the same order, I mean they will be paste in column B-E-G not in A-B-C. How to do this, please?

Hello Guys, I've been browsing for a while now and can't make it work. I've seen all the steps i need made on different threads but i can't join them due my lack of VBA syntax knowledge. Therefore I'm looking for help in the forum that helped me the most!! I have a user colored dynamic range...

Hi! So i have a data set that is exported by a database, so can't change it's format. I have a script to copy and paste it into my sheet and it works fine: 'set the range reference variables Set Bk = Sheet3.Range("C5") 'file path of book to import from Set Sh = Sheet3.Range("F5") 'sheet to...

I was hoping for some help creating this code. The part that is really throwing me off is having to paste values but also have them transposed at the same time. Let me know if anything is hard to follow. Any help would be greatly appreciated! 1. Copy B2 from sheet “Data Entry”, paste to first...

I need a macro to copy data from one sheet to another. In sheet 2 i need to copy data from the same row in a range between columns C to H. The row will change to be the bottom row with data in it.(can a formula be in the cell and it not be recognised by this if it is blank? or am I asking too...

Hello everybordy, I am new on VBA and I am tryng to copy specifc values from Sheet2 to Sheet1, but i don't know how to concatenate this values and how to copy the right values. My code copies but it's not working as i was expecting. Here is my code. Sub copyvalues() 'Declaration of...

Hi all I have a large data table in varying size 300 - 6000 rows, 20 columns. I am trying to sort the data for display purposes, mainly graphs, so I am using.. Sheets("Data Display").Range("B33:B6033").SpecialCells(xlCellTypeVisible).Copy Destination:=Sheets("Calc").Range("A10000") and...

Hi there, I'm trying to copy and paste a table filtered by a criteria.. It's working fine when the value exists, but when the value is not available.. e.g. "0", it's copying the entire unfiltered table and pasting. I want it to do nothing.. any tips? Thanks in advance! Sub Property16()...

Hi, Could you please help me with a hint for my problem or maybe you can make a tutorial with it. How to paste some data over hidden cells by a filter So i have one table with 3 columns A,B and C and 10 rows. In column A i have Name, in column B i have AWB and in column C Total. In column C i...

Hi after realizing that I needed a macro and after realizing that it was just a bit messy for me I asking for help. I have several folders. In each folder I have about 25 spreadsheets with numerical data (nothing fancy). In each sheet there are many more columns and they vary with size. what...