VBA to copy relevant data and populate a template sheet

Thanks, the code works but as the data contains formula's i just need it to copy over values?

' Bump - no repsonse '

You are a star. Works great! many Thanks!!!!!

slightly off topic, when i run the code for some reason on my front sheet it makes column A & B wider than normal??? any ideas?

Ken,
You are right!
This line is the culrpit

Please Login or Register  to view this content.

Comment it, or delete it, or if you could choose which columns you wish to adjust. I was too lazy and did all

Thanks, i don't need any autofit on the data so will just remove it.

Many thanks again,

Following this code i have identified a number of new lines of data that as part of the process don't have an identifier (column C) on postion template, is there a way to highlight any 0 or #N/A as part of this data and copy these to a new sheet called 'New Portfolios)??

Ken,
It is possible, but you need to show me your data. Currently, Column C on position template is blank, so where are the data coming from, or you mean column B which has identifier header on position template .

Try this one and if you are happy with it, I can incorporate in the origianal code as one

Please Login or Register  to view this content.

The concept of that code works great.

I think i need to alter it though, i need to identify the data as part of the final outputs of the data on sheet1 & sheet2 from column N.

The data that is copied over to the new portfolios tab should be the line of data column A to G.

Hope this makes sense

Ken,
Before this code, column N of sheets 1 and 2(User Identifier column) were copied in to position template of column B. So, you want to copy column A-G of both sheets in to new portfolios. If so, what do you want to do with the 0 and N/A? Or how do you want to change the first code to accommodate your latest request? I am not sure. Please explain

Searching for N/A & 0 is the identification of new portfolio's for me to be able to map these somewhere i need to core data of these new portfolio's.

As part of the code, search for #N/A & 0 within sheet1 & sheet2 then copy columns A:G into the new portfolio sheet.

Okay,
Do you want to search the whole sheet, or just column N only?

Just column N of both sheet1 & sheet2.

I do not think you have N/A in other columns, so assuming only column N to search and copy range A-G.

Please Login or Register  to view this content.

Thanks, i get the following message when i run the code

Well, I do not know, but it may be a linked formula you have, so I have amended the code to copy values only

Please Login or Register  to view this content.

You are a star!!

Thank you so much for your help on this...

Hope to work with you again in future

You are welcome!

AB33,

just wanted to pose a question, is it possible to retrieve different columns of data in no particular order of can i only return columns next to each other?

Ken,
This thread has been closed not only once but twice. Please re-start a new thread.