need done in 8 hrs
tjhuse
documents--bis155_w5_lab5_instructions_step1.pdf
Copying Files Across Workbooks Lab 5, Step 1 A. Save all of the wk5_Chap7_cap iLab files to one folder. You should have the
following files:
B. Open the Summary workbook in Excel. C. Open one of the files you wish to consolidate into this workbook. From the Home tab,
the Cells group, the Format option, select Move or Copy Sheet.
From the Move or Copy dialog box, select the Summary worksheet as location, Move to End, and Create a Copy:
Click OK. Copy the Eastside and Westside data in the same way. Your worksheet will now look like this:
Save this consolidated file as Lab5_yourlastname.xlsx. Note: Use the Switch Windows command from the View tab to see what is open, and use the Close button to close all worksheets except the Lab 5 Summary worksheet.
Your Lab 5 Summary worksheet should now look like this:
