 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2006Dynamically creating entries in worksheets
Is it possible to dynamically create entries in a worksheet based on th entry in another worksheet? If so, can you point me in the righ direction. Thanks in advance This formula, in a cell in Sheet2, will return the value in cell A1 of Sheet1.... =Sheet1!A1 HTH Vaya con Dios, Chuck, CABGx3 > Is it possible to dynamically create entries in a worksheet based on the > entry in another worksheet? If so, can you point me in the right > direction. > > Thanks in advance. Great, thanks! What if I need the values of worksheet#2 based on any value entered in a particular column in worksheet#1? In any other words, if I have entries in column "A" on workseet#1, in which the entries positions aren't static, how can I account for that in worksheet#2. What I have is 2 worksheets, the first captures project data and the second associates resources to it. These projects are identified by project# and depending on how many rows the previous project occupies, the next project# can start on any given line. Ken  Signaturekyoshida If you put the formula I gave you, ( =Sheet1!A1 ) in cell A1 of Sheet2 and copy and paste it down column A of Sheet2, it will reproduce column A of Sheet1 on sheet2.....all data will be in the same order it was on sheet1..........is that what you're looking for? Vaya con Dios, Chuck, CABGx3 > Great, thanks! What if I need the values of worksheet#2 based on any > value entered in a particular column in worksheet#1? In any other [quoted text clipped - 8 lines] > > Ken Thanks! I'll give it a shot I tried entering: "=CHIP Tasks!A1" into A1 of the 2nd worksheet and I get this = "=CHIP '[Tasks]CHIP Tasks'!A1" and then an Invalid name error. Any clues? Signaturekyoshida Try this....to cover the space in the SheetName........ ='CHIP Tasks'!A1 Vaya con Dios, Chuck, CABGx3 > I tried entering: "=CHIP Tasks!A1" into A1 of the 2nd worksheet and I > get this = "=CHIP '[Tasks]CHIP Tasks'!A1" and then an Invalid name > error. Any clues? I tried "='CHIP Tasks'!A1", but that only gets me the value of "A1". I need all the values from column A to appear in worksheet #2. Is there a way to do that? Signaturekyoshida Actually, I got it to work, but how can I force a blank space and not "0" if the field in empty Ok - nevermind on that one to. Sorry! But, here's a good question. I have the rows from ws#1 column A updating column A on ws#2. Because of the formula, the values on ws#2 show on the same lines as they do on ws#1. On ws#2, I need to remove the empty rows that are created. Is there a way to do this? Thanks, Ken Signaturekyoshida Right-click > Delete, on each blank row..........or use the respective feature in ASAP Utilities, a free Add-in available from www.asap-utilities.com Vaya con Dios, Chuck, CABGx3 > Ok - nevermind on that one to. Sorry! But, here's a good question. I > have the rows from ws#1 column A updating column A on ws#2. Because of [quoted text clipped - 6 lines] > Thanks, > Ken Thanks again for the help. One last question... Can you copy the cell formatting over as well? So, if the cell is green in ws#1, can you put that in the formula as well for ws#2? Thanks Signaturekyoshida No, unfortunately that feature is not supported.......a lot of folks would like that. Vaya con Dios, Chuck, CABGx3 > Thanks again for the help. One last question... Can you copy the cell > formatting over as well? So, if the cell is green in ws#1, can you put > that in the formula as well for ws#2? > > Thanks Wrap the formula in an IF statement......... =IF('CHIP Tasks'!A1="","",'CHIP Tasks'!A1) Vaya con Dios, Chuck, CABGx3 > Actually, I got it to work, but how can I force a blank space and not a > "0" if the field in empty? To capture data from one worksheet to another in the same workbook you might want to try a code range formula. This works when you can identify several values that need to be captured, either in total or individually from one page to another. However the more individual numbers you have the more codes you need. Your worksheet identifies individual costs associated with a project. Project A Labor hourly $35,000 Labor salary $25,000 Concrete $11,000 Wire $4,000 Next, in the next column,first label it "Code", then give each value a code. Labor hourly code 1, Labor Salary code 2, Concrete code 3, wire code 3. These codes can be associated with each cost center. Next define the range for both Total and Code columns. You do this by going to Insert->Name->Define. Enter the name you wish to define and click the little icon in the refer to box. THis will identify the range to search for your data. On your next worksheet page you may want a total for each cost center. In the first column you identify the code associated. Next column your description. In you total column your formula would be =ROUND(SUMIF(Code,$A8,1st worksheet total column),0), where $A8 is the code on your current worksheet in the first column, "1st worksheet" is whatever your worksheet data name is. You do not have to round. This is a great way to automate. C Craig Signatureccraig61 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.