Hi,
I have a series of sheets all of which contain data arranged under a series of different headers. I have then created a master sheet which contains all of the headers i have used. Can the "IF" function be used in the master sheet to say if sheet 1, sheet 2 and sheet 3 has data arranged under the heading "organisation" put all of those organisations in the master sheet under the header of that name? I have about 40 different headers across 12 sheets.
Last edited by excelthicky; 07-21-2017 at 01:21 PM.
It can be done rather handily with VBA - what are the specifics i.e. sheet names, headers etc?
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Well there are 12 sheets (numbered one to 12) and then about forty headers;
Organisation
Fortune 500
Industry
Industry2
Salutation
First Name
Last Name
Job Title
Tel No
Mobile No
Address 1
Address 2
Address 3
Address 4
Town
Postcode
County
Country
Immediate parent
Ultimate parent
Company total spend
Company radio spend
Company TV spend
Company outdoor spend
Company press spend
Company direct mail spend
Company cinema spend
Company internet spend
Contact status
Address 2
Town1
County1
Postcode1
Country1
Database Spend
Monitoriong Spend
DMAS
G Account Owner
G Account level
Analysis Spend
Approximate start date
Well, without a sample it's untested but to run it put whatever headers you want in a Sheet named "Master"
and have the source sheets actually named 1 to 12:
Please Login or Register to view this content.
And, Thanks for the rep!
Last edited by xladept; 07-21-2017 at 02:37 PM. Reason: index
Thanks so much for your help. Do the sheets need to be numbered "1, 2, 3 etc" or "sheet1, sheet2, sheet3 etc". I've tried running the code with the sheets named sheet1 etc but am getting the following error;
Compile error, Type Mismatch and then it highlights "Sub ExcelThicky ()"
The sheet names are just integers like it was on your sample
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks