How to save data from one sheet to another sheet using vba

[zaska]

Hello,

I have data in Sheet "Raw" and I want to copy the data into Sheet "Main" column"B" against matching tickers by shifting columns to right till 300th column
I want to do this till 300th column and whenever new data is copied after 300 columns the last column should be deleted for inserting the fresh data in Column"B". i.e I want to maintain data for 300 days only

I am herewith attaching the sample file

Thank you

[BadlySpelledBuoy]

Maybe this will work for you.

Please Login or Register  to view this content.

BSB

[zaska]

Thank you for the help. When there are no corresponding values the cells values are displayed as #N/A, How to avoid this and make it '''" if there is no corresponding matching data.Also, If new symbol name gets into raw data how to copy new symbol also to Main sheet?

Once data is saved to main sheet can we avoid duplication of copying the same data again?

[BadlySpelledBuoy]

Try this

Please Login or Register  to view this content.

BSB

[zaska]

I have added few lines to run the query in loop and get the data and copy for various dates, Can it be improved or shortened further?

I also changed the date cell to B2 in Targetsheet because I kept first row as blank in Targetsheet. Does it require any change in the offset and resize lines of the code ?

Please Login or Register  to view this content.

[BadlySpelledBuoy]

I also changed the date cell to B2 in Targetsheet because I kept first row as blank in Targetsheet. Does it require any change in the offset and resize lines of the code ?

I don't think the offset and resize lines would be affected by that. But it would be easier for you to tell by trying it in your workbook.
If the workbook is laid out differently to your sample file then it may need tinkering with, but we'd need to see the file to know for sure.
Always best to have your sample file laid out exactly the same as your real file as it will save a lot of followup work.

BSB

[zaska]

Yes, you are right the offset and resize lines were not affected. Thank you