Copy the data from one sheet to other only values.

[kittu55]

Hi all,

I'm facing a problem and need some help to sort it out.

I have a work book which has 2 sheets. The 1st is the daily log an the 2nd is a monthly one. The data from 1st sheet (starts from A5) needs to be updated into the 2nd sheet on a daily basis. However 1st sheet contains some formulae which are not needed in the 2nd sheet i.e. the data should be copied as values in the 2nd sheet. Another thing is the data already present in sheet 2 should be checked, and if any duplicate value is found it should be removed.

Thanks in advance..

[kittu55]

Can some one help me on this plz ? ?

[Debraj Roy]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[kittu55]

Hi i have attached the sample workbook. Please have a look at it.

Thanks

[AB33]

Try the attached. I have inserted a dummy data in the last row in sheet month.

[kittu55]

HI AB33,

This works fyn. ThanQ very much for the help.

I just want to know if there's an option of copying some columns along with the formulae and copying the rest as values.

[AB33]

Not with arrays.
If you want to copy formulas and values, it has to loop through the cells.

[kittu55]

Sorry I cannot understand. Can u plz elaborate..

[AB33]

This was what you said

"However 1st sheet contains some formulae which are not needed in the 2nd sheet i.e. the data should be copied as values in the 2nd sheet".
The code uses looping though an array, not a range, so can only copy values ONLY.

[kittu55]

Ok AB33. Than Q for the help.

Thread Closed and REP Added..

[Debraj Roy]

Thanks for feedback..