Combining Tabs

[helenshas]

Hi
I have multiple tabs for different companies Actual, forecasts, and budgets, most have the same descriptions for example
Sales
Salaries
Car Hire
Rental
Vehicle Leasing

Other companies have more than these titles and some are on different cells, is there a lookup that I can use to combine them all on one spreadsheet as I need to do a group report on all of them

thanks
Helen

 

[helenshas]

no, you need to use the report button and ask a moderator if they would delete

No, I meant in Excel
you have a menu button XL2BB
and then you select the area
and click on Mini sheet and that copies
then you paste here

There is a test forum here, you can try out
I think because your data is linked - i'm not seeing anything come up in xl2bb

or you can put on a share , like dropbox / onedrive

You can also test to see if it works ok, in the "Test Here" forum.

Test Here

Use this forum to test your signature, learn bbcode, smilies, XL2BB, etc. Threads in this forum are automatically deleted after no replies for seven (7) days

www.mrexcel.com

Hi I have added it in a previous reply so you should be able to see it now thanks

 

[etaf]

I saw that on post #7
and i was referring to that info

I think because your data is linked - i'm not seeing anything come up in xl2bb

should have been clearer
I have copied the XL2BB from post #7 , and its not providing any information - just heading , and then because of links outside your workbook, i just get REF
and not really sure what you want to do

sorry , this is proving difficult to provide information

 

[helenshas]

I saw that on post #7
and i was referring to that info

should have been clearer
I have copied the XL2BB from post #7 , and its not providing any information - just heading , and then because of links outside your workbook, i just get REF
and not really sure what you want to do

sorry , this is proving difficult to provide information

Reveiw of Spreadsheets.xlsx
	D
18
Grouped Summary

I saw that on post #7
and i was referring to that info

should have been clearer
I have copied the XL2BB from post #7 , and its not providing any information - just heading , and then because of links outside your workbook, i just get REF
and not really sure what you want to do

sorry , this is proving difficult to provide information

Reveiw of Spreadsheets.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1
2
3
4
5
6			Head Office Actuals 22-23
7	0.02
8															Total
9	Sales.		Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar	YTD
10	Sales		0	0	0	0	0	0	0	0	0	0	0	0	0
11	Accrued Sales - Current Month		0	0	0	0	0	0	0	0	0	0	0	0	0
12	Accrued Sales - Previous Month		0	0	0	0	0	0	0	0	0	0	0	0	0
13	WIP - Current Month		0	0	0	0	0	0	0	0	0	0	0	0	0
14	WIP - Previous Month		0	0	0	0	0	0	0	0	0	0	0	0	0
15
16	Sales Total		-	-	-	-	-	-	-	-	-	-	-	-	-
17
18	Monthly Cost of Sales
19	Cost Of Sales Accrued		-	-	-	-	-	-	-	-	-	-	-	-
20	Materials	F	-	-	-	-	-	-	-	-	-	-	-	-	-
21	PPE Equipment	F	-	-	-	-	-	-	-	-	-	-	-	-	-
22	Client Fees	F	-	-	-	-	-	-	-	-	-	-	-	-	-
23	Plant/Equipment Hire	V	-	-	-	-	-	-	-	-	-	-	-	-	-
24	CIS Labour	V	-	-	-	-	-	-	-	-	-	-	-	-	-
25	Reah Group Labour		-	-	-	-	-	-	-	-	-	-	-	-
26	CIS Materials	F	-	-	-	-	-	-	-	-	-	-	-	-	-
27	Consultancy	F	-	-	-	-	-	-	-	-	-	-	-	-	-
28
29	Cost of Sales Total		-	-	-	-	-	-	-	-	-	-	-	-	-
30
31	Salaries.
32	Salaries	V	-	-	-	-	-	-	-	-	-	-	-	-	-
33	Salaries Office	F	-	-	-	-	-	-	-	-	-	-	-	-	-
34	ERS NI	V	-	-	-	-	-	-	-	-	-	-	-	-	-
35	ERS NI - Office	V	-	-	-	-	-	-	-	-	-	-	-	-	-
36	Pension Contributions	V	-	-	-	-	-	-	-	-	-	-	-	-	-
37	Pension Contributions - Office,	F	-	-	-	-	-	-	-	-	-	-	-	-	-
38	Pension Contributions - Office	F	-	-	-	-	-	-	-	-	-	-	-	-	-
39	Salaries Total		-	-	-	-	-	-	-	-	-	-	-	-	-
40
41	Expenses
42	Vehicle Rental		-	-	-	-	-	-	-	-	-	-	-	-	-
43	Tracking	F	-	-	-	-	-	-	-	-	-	-	-	-	-
44	Vehicle Leasing	F	-	-	-	-	-	-	-	-	-	-	-	-	-
45	Vehicle Repairs	F	-	-	-	-	-	-	-	-	-	-	-	-	-
46	Vehicle Fuel		-	-	-	-	-	-	-	-	-	-	-	-	-
47	Mileage Allowance	V	-	-	-	-	-	-	-	-	-	-	-	-	-
48	Vehicle Insurance	V	-	-	-	-	-	-	-	-	-	-	-	-	-
49	Parking Costs	V	-	-	-	-	-	-	-	-	-	-	-	-	-
50	Parking Fines	F	-	-	-	-	-	-	-	-	-	-	-	-	-
51	Other Vehicle Costs	V	-	-	-	-	-	-	-	-	-	-	-	-	-
52	Vehicle Tax		-	-	-	-	-	-	-	-	-	-	-	-	-
53	Fares	V	-	-	-	-	-	-	-	-	-	-	-	-	-
54	Accomodation	V	-	-	-	-	-	-	-	-	-	-	-	-	-
55	Marketing	V	-	-	-	-	-	-	-	-	-	-	-	-	-
56	Advertising	V	-	-	-	-	-	-	-	-	-	-	-	-	-
57	Uniform	V	-	-	-	-	-	-	-	-	-	-	-	-	-
58	Postage	V	-	-	-	-	-	-	-	-	-	-	-	-	-
59	Office Stationary	V	-	-	-	-	-	-	-	-	-	-	-	-	-
60	IT Support		-	-	-	-	-	-	-	-	-	-	-	-	-
61	Internet		-	-	-	-	-	-	-	-	-	-	-	-	-
62	subscriptions		-	-	-	-	-	-	-	-	-	-	-	-	-
63	Accounting Services		-	-	-	-	-	-	-	-	-	-	-	-	-
64	Waste		-	-	-	-	-	-	-	-	-	-	-	-	-
65	Rent and Rates		-	-	-	-	-	-	-	-	-	-	-	-	-
66	Health Insurance		-	-	-	-	-	-	-	-	-	-	-	-	-
67	Public & Employers Liability		-	-	-	-	-	-	-	-	-	-	-	-	-
68	Professional Indemnity Insurance		-	-	-	-	-	-	-	-	-	-	-	-	-
69	Office Insurance		-	-	-	-	-	-	-	-	-	-	-	-	-
70	Directors & Officers Insurance		-	-	-	-	-	-	-	-	-	-	-	-	-
71	Telephones		-	-	-	-	-	-	-	-	-	-	-	-	-
72	Mobile Telephones		-	-	-	-	-	-	-	-	-	-	-	-	-
73	Mobile Telephones - Office		-	-	-	-	-	-	-	-	-	-	-	-	-
74	Legal & Professional		-	-	-	-	-	-	-	-	-	-	-	-	-
75	Human Resources		-	-	-	-	-	-	-	-	-	-	-	-	-
76	Electricity		-	-	-	-	-	-	-	-	-	-	-	-	-
77	Bank Charges		-	-	-	-	-	-	-	-	-	-	-	-	-
78	Service Charges		-	-	-	-	-	-	-	-	-	-	-	-	-
79	CHAPS Fee		-	-	-	-	-	-	-	-	-	-	-	-	-
80	Leumi Discount		-	-	-	-	-	-	-	-	-	-	-	-	-
81	Leumi 3 Day Discount		-	-	-	-	-	-	-	-	-	-	-	-	-
82	Iwoca Loan Interest		-	-	-	-	-	-	-	-	-	-	-	-	-
83	Training & Development		-	-	-	-	-	-	-	-	-	-	-	-	-
84	Staff Meetings		-	-	-	-	-	-	-	-	-	-	-	-	-
85	Entertainment		-	-	-	-	-	-	-	-	-	-	-	-	-
86	Charity Donation		-	-	-	-	-	-	-	-	-	-	-	-	-
87	Miscellaneous		-	-	-	-	-	-	-	-	-	-	-	-	-
88	Suspense Account		-	-	-	-	-	-	-	-	-	-	-	-	-
89	Entertainment
90
91
Grouped Summary

 

[etaf]

i'm really sorry, I'm at a lost from the sample what you are wanting to do

is the XL2BB a Summary, one of the tabs , i'm assuming the summary , as it says HEAD-OFFICE

is the layout of the other company tabs - same layout exactly cell for cell
OR ?

i think more info and some examples of what you are trying to pull together
maybe a 3D Sum may work , if the layout is the same
"=SUM(Sheet1:Sheet4! A2)"

or a Grid lookup , but would need multiple lookups added together

but as i say , without more detail, samples and example of the results expected, really not sure what you want

other members may understand and reply

 

[helenshas]

i'm really sorry, I'm at a lost from the sample what you are wanting to do

is the XL2BB a Summary, one of the tabs , i'm assuming the summary , as it says HEAD-OFFICE

is the layout of the other company tabs - same layout exactly cell for cell
OR ?

i think more info and some examples of what you are trying to pull together
maybe a 3D Sum may work , if the layout is the same
"=SUM(Sheet1:Sheet4! A2)"

or a Grid lookup , but would need multiple lookups added together

but as i say , without more detail, samples and example of the results expected, really not sure what you want

other members may understand and reply

Hi Maybe I will explain it a bit more
I have these titles on each tab but not all of them are on each tab as they are not needed, each tab has the P&L and I need to make a group P&L, the + formula on each tab will be quite long to do, so was wanting a lookup or something to group them in one so its easier not to make a mistake
does that help

Vehicle Rental

Tracking

Vehicle Leasing

Vehicle Repairs

Vehicle Fuel

Mileage Allowance

Vehicle Insurance

Parking Costs

Parking Fines

Other Vehicle Costs

Vehicle Tax

Fares

Accomodation

Marketing

Advertising

Uniform

Postage

Office Stationary

IT Support

Internet

Subscriptions

Accounting Services

Waste

Rent and Rates

Telephones

Mobile Telephones

Mobile Telephones - Office

Legal & Professional

Training & Development

Staff Meetings

Entertainment

Compensation

Charity Donation

Miscellaneous

Suspense Account

Electricity

Entertainment

Health Insurance

Public & Employers Liability

Professional Indemnity Insurance

Office Insurance

Directors & Officers Insurance

Human Resources

Gas

Bank Charges

Service Charges

CHAPS Fee

Leumi Discount

Leumi 3 Day Discount

Iwoca Loan Interest