Files vs tabs

Harley78

Active Member
Joined
Sep 27, 2007
Messages
369
I have a question which is better, separate tabs or files? Heads up, Sorry for being long winded

My main report (Parts Daily Status Report) I copy and past rows/columns from the Balance due report. I pull data from other files so I just need to look on this report only and update only the others. I am using many Vlookups across the files as well as formulas. Wouldn't think this would be a problem however, it seems to create issues I do not like to see. Causes a slowdown (Spinning) and crashes.

Steps:
File 1: Parts Daily Status Report I copy and paste columns rows from the beginning of the day as this changes daily from the current Balance due report. I have Vlookups on this report as well, pulling data from Freight and Dispo ****pit reports
File 2: Freight report
looks at goods receipt report using a vlookups to determine if it arrived how many and when Formulas that determine the transit times. I update this daily with orders that have been shipped by the supplier.
File 3: Goods Receipt Report I copy and paste what was received day prior from another report I run from SAP
File 4: Dispo ****pit report form SAP, is copied and pasted to its own report

So to get to the question. What is the best setup? To combine files into one file using tabs or keep them separate into file? Is copying pasting updated info to all the files causing issues? just wondering why it crashes and slows down the update (Spinning)
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Harley78

Active Member
Joined
Sep 27, 2007
Messages
369
I also forgot I have another file with Parts information that updates the Freight file with weight. So I would have 6 tabs in one file or 6 separate files. I would assume that it would be best to go tabs but that is a lot of vlookups and data in one file. Just wondered if anyone has any suggestions and or experienced this and what the fix was?
 

Watch MrExcel Video

Forum statistics

Threads
1,126,952
Messages
5,621,798
Members
415,856
Latest member
jimb2k

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
Top