Hello,
I am currently working on a bid sheet for my company; the accounting department has new software and they need me to alter my spreadsheet to fit a format that is suitable to import into their system.
I will try to explain this as simple as possible (I have attached an example spreadsheet as well)
Sheet1: Estimate
Sheet2: Cost Code Import Sheet
I need to take the information from Sheet1 and have it converted to fit sheet2 and there are a few issues I'm having:
#1 I need the line items in column B on Sheet1 (B2,B3,B4) referenced on Sheet2 but every 4 rows (E2,E6,E10)
#2 Now that I have 3 blank rows between my line items, I need to reference the cost amounts in cells F2,G2,H2 (sheet1) onto sheet 2 (D3,D4,D5)
I know this might be confusion, I tried my best.
so far, I have been changing the reference in every cell, and I have hundreds of line items... I do not think I will maintain what little sanity I have left if I continue doing it this way
please help!
Bookmarks