Generating third worksheet from two others

  • Thread starter Thread starter MIchael
  • Start date Start date
M

MIchael

I have two worksheets, one called NETINCOME that has
revenue and cost data. The other is SG&A that has other
expenses. They have the same format in terms of rows and
columns. I would like to create at third worksheet that
would have the NETINCOME worksheet at the top and the SG&A
worksheet below. I'd like to keep making changes in
NETINCOME and SG&A and have them reflected in the combined
sheet. Does anyone have a suggestion on how I could do
this most easily? Thanks. Michael
 
Hi

Open a Blank workbook and NETINCOME.
In the blank workbook, A1 type = and switch to NETINCOME (Window Menu) and
click on A1 in NETINCOME and press Enter.

The formula is =[NETINCOME]Sheet1!A1.Copy this formula doewn and accross.

Repeat for SG&A

Regards
Peter
 
You must log in or register to reply here.

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

Sega retro console 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Merging two similar worksheets 10
Two worksheets to one 3
Variable input to populate data fields 3
Code to Look for Text and then Perform Specified Actions 1
News AMD announces third generation Ryzen CPUs 2
Need to merge worksheets - Excel 2003 0

Back
Top