Paste special values from one sheet to another using VBA code in excel

Hi,

I have some data in columnA (A1 to A1000) i want to copy and paste special values (column A is having some formulas) to another sheet using VBA code, and also in another sheet this 1000 cells has split in to 3 columns the cut of point is 300. I dont want to do this manually i want to do this using some Code

example in sheet 1 Column A I have 1 to 1000 numbers (A1 to A1000) i want to copy and paste special these 1000 numbers in to sheet2 in Column A,B,C means in sheet 2 up to 300 numbers in ColumnA and from 301 to 600 in column B and 601 to 900 in column C remaining in Column D

Thank you so much for your help

Try:

Please Login or Register  to view this content.

Thank you so much for you immediate response,

Please tell me where I have to copy this code is it in sheet1 or sheet2

I have a small doubt please tell me whether this code will copy and paste special as values from sheet1 to sheet2 automatically means once i will enter data in sheet1 the sheet 2 will get the paste special values from sheet1 in multiple columns with cut off each column is 300

Thank you

Place it in a module. in VBE, right click on your workbook and insert -> module. Copy and paste the code in, then go to your workbook, press Alt + F8 and run it.

Please Login or Register  to view this content.

Originally Posted by chavanalini

Please tell me where I have to copy this code is it in sheet1 or sheet2

If you don't want to use a macro, use this in Sheet2.Range(A1:D300) 'if you use it beyond that range it should also work, values will be blank. Formulas will be pasted.

Please Login or Register  to view this content.

My advice is just to use millz VBA script

Hi,

formula is not working giving error,

Thanks

replace ; by ,
Then it should work

Thank you so much it is working