copying names to different sheets without added 0's in excel?

Question

I currently have an excel spreadsheet that I have multiple tabs on, each tracking a different set of stats... the only thing that is constant between all the sheets is the employee names, since we have so many that come in and out of our company it is getting to be a big time consumer to constantly update each sheet with the new names, what I would like done is for one sheet to be the master sheet, with all the names, and when I add a name on that sheet, it copies over to all the other sheets... I have achieved this sorta, but the only problem is when I give the range, I am going over the number of employees we have to give some cushion for new employees, but when I do that I get 0's that pop up in that place on all the other sheets, is there anyway to keep this from happening? If you need more info please let me know!

Answer 1

Use the following expression and copy that to every cell that will have the Name:



=IF(ISBLANK(Sheet1!A1),"",Sheet1!A1)

Answer 2

in case your archives in column A runs from A3 right down to A50 (i'm assuming the first 2 rows of your sheet are taken up with significant heading and column headings), interior the subsequent sheet in basic terms style the function =sum(sheet1!A3:A50), or once you've the entire interior the first sheet having performed an autosum functionin cellular A51, on your 2d sheet, style the = then click on the first sheet and double click in cellular A51 so the formulation is going in immediately.

Answer 3

If you use Nahee's formula =IF(ISBLANK(Sheet1!A1),"",Sheet1!A1), and you insert a row on Sheet1, you will need to insert a row on all your other sheets as well. You can quickly accomplish this by selecting all the sheets. Select the first sheet, the hold the shift key and select the last sheet. Now once all the sheets are selected, you can insert the row where you would like it. Now all the sheets have a blank row in the correct location. You need to copy the formula =IF(ISBLANK(Sheet1!A1),"",Sheet1!A1) into the blank row on each sheet. A quick way to do this is to select all the sheets except the first sheet and then copy the formula from the row above the new blank row into the new row. Because you have all the secondary sheets selected, the formula will be copied an all the secondary sheets. You are now ready to go.



It is possible to automate this if you wish. For immediate help go to http://www.crossloop.com/PCS_Help