slopesoccer3
New Member
- Joined
- Apr 15, 2011
- Messages
- 1
HI!
I have been working on a spreadsheet for multiple days now trying to figure out how to add new entries on one worksheet and having it update the other worksheet with the same new row. The first worksheet has multiple columns of data that is hard coded in. The second worksheet has some of this data in it and it is transfer via IF functions. Also, it has additional columns. I work at an accounting firm and they need to hard code dates in and then on the second worksheet it puts the important dates and then the additional columns state the date the "product" should have been finished. If it was finished in time it says yes and if not it says no. This part took me a long time to do but now when i input new clients it and click on the list function i set up to alphabitize the data it doesn't stay all together in both worksheets. Even if I input the new client in the first row in both work sheets. The formulas do not want to transfer either to the new entry column.
I know if i just have the employee input the data in the correct alphabetical order and not use the list function to do it and then drag the formula down it will work but this has a huge risk of getting messed up since accountants like to take the easy road and have the list function sort it for them. I do not want to take out the list function because it helps them narrow down the list of clients they want to look at. PLEASE help! I am not very good with excel and the fact that I have gotten this far is a surprise.
Thanks
I have been working on a spreadsheet for multiple days now trying to figure out how to add new entries on one worksheet and having it update the other worksheet with the same new row. The first worksheet has multiple columns of data that is hard coded in. The second worksheet has some of this data in it and it is transfer via IF functions. Also, it has additional columns. I work at an accounting firm and they need to hard code dates in and then on the second worksheet it puts the important dates and then the additional columns state the date the "product" should have been finished. If it was finished in time it says yes and if not it says no. This part took me a long time to do but now when i input new clients it and click on the list function i set up to alphabitize the data it doesn't stay all together in both worksheets. Even if I input the new client in the first row in both work sheets. The formulas do not want to transfer either to the new entry column.
I know if i just have the employee input the data in the correct alphabetical order and not use the list function to do it and then drag the formula down it will work but this has a huge risk of getting messed up since accountants like to take the easy road and have the list function sort it for them. I do not want to take out the list function because it helps them narrow down the list of clients they want to look at. PLEASE help! I am not very good with excel and the fact that I have gotten this far is a surprise.
Thanks
