Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
*Assistance with formula*
I have data in spreadsheet 1 that consists of 8 columns and 2500 rows
The data is laid out as follows Col A Col B Col C Col D Col E Col F Col G Col H Row 1 AL BF0050C Bigfoot 1000 800 200 Smithfield 200 Row 2 VA CS0027F Smith 200 120 80 Austin 215 Row 3 GA HN4237D Maximum 1000 750 250 Smithfield 200 I am trying to pull the information into a spreadsheet consisting of 4 columns Col A Col B Col C Col D Row 1 3/31/08 =H1&"-4005-"&A1 -D1 =B1&" - "&C1 Row 2 3/31/08 =H1&"-5360-"&A1 E1 =B1&" - "&C1 Row 3 3/31/08 =H2&"-4005-"&A2 -D1 =B2&" - "&C2 Row 4 3/31/08 =H2&"-5360-"&A2 E1 =B2&" - "&C2 Row 5 3/31/08 =H3&"-4005-"&A3 -D1 =B3&" - "&C3 Row 6 3/31/08 =H3&"-5360-"&A3 E1 =B3&" - "&C3 I need to have 2 rows per line of the original data and need to be able to create for various number of rows Any ideas on how to automate or copy or use fill to get every other row to look at the next row in my data spreadsheet? Thanks in advance for any assistance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula assistance | Excel Worksheet Functions | |||
Formula assistance | Excel Discussion (Misc queries) | |||
Formula Assistance | New Users to Excel | |||
Formula Assistance Please | Excel Worksheet Functions | |||
Formula Assistance | Excel Worksheet Functions |