User Profile
Skpenu505
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
- 1.7KViews0likes1Comment
Re: EXCEL URGENT HELP!
Thank you mathetes Ricardo Viana !! You've both being of great help. I appreciate you both. I believe the second part of my question wasn't clear. On "page 2&3"under Column G is the amount for each expense coded with the fund code on (column B), how can I transfer the total on column G for each fund code(column B) to appear on Page 1 preferably on cell O43 with each fund code number to appear alongside the total. Hope this is clearer. Thanks!1.7KViews0likes3CommentsEXCEL URGENT HELP!
Hi, I recently joined the Excel Community because I urgent need help from an Excel spreadsheet expert. what function or formula can I used to narrow(lookup) a specific expenses to a particular departmental number. Also, what function can i used to calculate the total of all expenses coded to a particular department code and fund code.It would be a lot if I can get help on this issue. Solved2KViews0likes8CommentsRe: EXCEL URGENT HELP!
Ricardo Viana Omg you are the Champ! Thanks so much for helping! i got another question how can I make the total expense amount populate on page 1 for each individual fund code( if this could appear under the the pivot table on page 1). Also on "sheet 2& 3" i would like to narrow fund code to particular department codes-meaning when i fill in my department code on sheet(page) 1 cell B1, only fund codes related to that department will show in page 2 column B. Sheet 3(fund code) has all the fund codes that relates to a particular department or group of departments.1.8KViews0likes6Comments
Recent Blog Articles
No content to show