If Cell = X then name sheet Tab GHI for eg

D

Diddy

Hi everyone,

I'm importing worksheets which contain different data. I need to collate the
sheets into 1 workbook for each data collection site and need to keep sheet
tab names consistent.

The headings vary only slightly except for cell A4 which is a short
description of the dataset. This can be altered slightly by the user (e.g.
could be variations on Filling Line 1 QA or Fill Line 1 QA or Line 1 Fill QA,
different sheets are different line numbers and sometimes QC rather than QA)

So what I need (if any kind soul can help at all) is a way of saying if A4
contains "Line 1" and "QA" then the tab should be "Line 1 QA" then I need to
say or if it contains "Line 2" and "QC" the tab should be "Line 2 QC" etc for
7 different combinations.

If anyone could help that would be brilliant!

Thank you (Driving home now)

Diddy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for multiple prints 4
Trying to delete sheet code with VBA 2
Create if partial match then copy and paste data from one cell to another 1
creat sheets with assigned name and protected 4
Test for color of sheet tab? 3
search sheet names containing phrase then copy to cell 1
Change sheet name based on cell value from another sheet tab 2
Refering to new sheet name 3

Top