Scope of work EXAMPLE.xlsx
What I am trying to figure out is the following:
User input Column A (input in hours)
predefined items in Column B
First, in column G, I want a list of only the items that have an entry in column A without the blanks (as shown in the attached file).
Second, if not as simple as adding the 'Sheet2' to get it to populate in the 2nd sheet, what would I need to do to get it to this sheet?
I am at a loss on this. Any help would be appreciated.
Rich
Last edited by rjanw01; 11-14-2014 at 04:33 PM.
Hi, Try this and drag it down....
Formula:
Please Login or Register to view this content.
☚ Click ★ just below left if it helps, Boo?ath?
Thanks, works as needed.
Now to figure out how to automatically add/remove blank cells within a range for report to look as though it was typed in Word. Need this if anything is revised after reviewing the report. Will post in a few hours once I have it all laid out.
Ok fine...
Ok, been a busy couple of weeks but I finally got back to this. I have all the information filling in correctly from my Invoice Information tabs to the Contract tabs. What I would like to achieve is when half the items under "Submittal" on Invoice Information Example 2 are not filled in, the blank spaces between Submittal and Engineering items are not causing a large void area on Contract Example 2. Is this possible?
Scope of work-only 1 sheet.xlsx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks