How do I update a spreadsheet with numbers input into another?

M

Max

Duma said:
How do I link two speadsheets in order to update both at the same time?
Click to expand...

Probably something like this

In Sheet2,
In A1: =IF(Sheet1!A1="","",Sheet1!A1)
Copy A1 across/down to cover the extent

Sheet2 will then reflect entries/updates in Sheet1 for the formulated range
 
G

GuruGirl

If both spreadsheets are the same, headers, data ranges, titles etc,
basically same architecture on both sheets, then...

While on Sheet1, hold the shift key down, click Sheet2, now both are
highlighted. Now your sheets are "Grouped". anything you do on one, will be
applied to the other, including print page set ups.

Practice, be careful doing this as you can accidentally key something in all
sheets and not intend to while they are grouped.

Very handy though to set page set up same in all sheets quickly.

Does that help?
 

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

How to automate update on weekly reports spreadsheet 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Section and Page numbering 0
Finding the proper style field and the numbered paragraph value within the style 0
Paragraph numbering in Word 1
How can the font and size of (all) citation numbers be altered? 1
Dealing with a Pivot Table (when I don't want to) 0
Auto-Numbering in a Table in MS Word 1

Top