VBA for Business - Search across 2x pages with Transposing of Information

[tballard1994]

I have a Excel document made up of 2 worksheets - one entitled "Support Register' and the other entitled 'Services'

On the support register sheet, we have every client in Column B from Rows 9:120, and all our services across the top in Columns B8:ZZ8.

I am attempting to make it so when I search on the 'Services' sheet for a specific client, a search is run against the row which that client occupies on the 'Support Register' page and if there is any contents to any cell, copies the information in the services row (Row 8, B:ZZ) across onto the Services sheet in some useful format...

If am honest, I am not sure where to start so any pointers would be very very useful!!!

 

[JLGWhiz]

How is your Services sheet laid out and where on that sheet do you want the 'useful' format entered. Bear in mind that what is useful to one may not be useful to another.
Also, if you already have code to do the search for the client name on the Services sheet, then you should post that code. If you do not have the code, do you want that as part of this project?