choosing specific data only rows from a list of which includes headers/titles/subtitles

[unexecel]

Hello, I hope you are well.

Firstly please forgive my ignorance if this is an easy fix, but i have tried my best and cant find out how to solve this

I have an export spreadsheet which details information from column a to column p which i need ...(supplier code...net value..vat...comments..etc)

However there are also subheaders, sub totals titles which take up entire rows and contains data i do not need.

Is there a way of telling excel to choose certain rows (eg ...A19 to P19, A20, to P20, A45 to P45 )

depending on if the first cell of the rows i need eg Cell A19,A20, A45 etc contains a supplier code such as from the following list :

AC01NET
AD05
210
003
BL01
KF01
KF01
CA06

I would need to paste the selected rows into another sheet

Sorry if this is not clear

Thanks

[k64]

I'd need to see a sample workbook to help.

[unexecel]

Hey apologies

Please find attached file

first tab = list of accounts

second tab = data

[nilem]

Hi unexecel,
try it

Please Login or Register  to view this content.

Please note there are duplicate values ​​(KF01) in the worksheet 'Sheet'

[unexecel]

Hi

Firstly thank you for your reply i really appreciate the help

I have cut and paste the code in but when i run the macros it only displays entries for the accounts KF01 & WK01NET

See attachment (sheet 3 )

ITs bloody amazing tho what you have managed to do so far!!!!

[unexecel]

sorry forgot to add KF01 duplicate was a mistake should not be duplicated

Thanks

[nilem]

"...it only displays entries for the accounts KF01 & WK01NET"
Because only KF01 and WK01NET exist simultaneously on the sheet 'Sheet' and on the sheet 'Sheet1'
Perhaps I misunderstood your task

[unexecel]

Hi

I am so sorry i have added the wrong list in sheet "sheet"

I have since amended the list in sheet "sheet" but when i run the macros an error occurs?

Apologies for my stupidity i am trying to understand this but am finding it very tough

Thanks again

[nilem]

Hi unexecel,

Let's remove the extra spaces on the sheet1
Please try again

Please Login or Register  to view this content.

[unexecel]

IT WORKED



THANK YOU SOOOO MUCH

May i ask one more question please, if i wanted to add another supplier code to sheet "sheet" how would i amend range a1?

Thanks again you are the best!

[nilem]

Just add the supplier code in the last blank line in column A of the sheet "Sheet"
x =. Range ("A1",. Cells (Rows.Count, 1). End (xlUp)). Value will take all suppliers codes

Edited:
...in the first blank line...
oops

[unexecel]

Thank you sir