VBA to match cells and return 2 cells of data

SFPCFS

New Member
Joined
Feb 7, 2014
Messages
40
Hi All

I have a new issue that needs help

I have a main summary sheet and 3 team sheets

In colum a on all the sheets there is a unique referance number. This number though is only in order on the Summary sheet, and is split by a referance to the other team sheets

Can I use a VBA version of match and lookup to check each sheet in turn and were it matches the unique number bring back 2 cells (in colums u,v on all the sheets)
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
SFPCFS,

1. What version of Excel and Windows are you using?

2. Are you using a PC or a Mac?


Can I use a VBA version of match and lookup to check each sheet in turn and were it matches the unique number bring back 2 cells (in colums u,v on all the sheets)

I would say yes, but, we would have to see your summary sheet, and, the 3 team sheets.


Because of the width of your worksheets, screenshots would be out of the question.

Can you supply a sample of your workbook/worksheets, with the titles in their correct positions, but, only with columns that contain the unique referance number's, and, columns u and v?


You can upload your workbook to Box Net,

sensitive data changed

mark the workbook for sharing

and provide us with a link to your workbook.
 
Upvote 0
Hi

Its Excel 2010 that I am working in on a PC

I'll send a copy home to de-risk and upload to that area as mentioned (Works network won't allow me to do that)

Current Headings in use a

Colum a - Unique ID (Created by the following formula, =CONCATENATE(Sheet3!$A$9,IF(B10=COUNTA(B10)*1,"",ROW()-5),,T10)

The data colums I wish to return have the simple headsing of Compled and Completed Date

All Sheet up V are Identical, then the team sheets contain more information on each change, but for the purpose of this I only need to go to V

Many thanks for you quick response
 
Upvote 0

Forum statistics

Threads
1,213,551
Messages
6,114,272
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top