Hi all
I have a spreadsheet from an external source that I need to sort so that we can use the data to create a summary report.
We need to show the data with column headings Name eg Australian dollars, Ticket No, Buy, Sell ,Value for each.
The problem is the spreadsheet we receive has
Australian Dollars at CD R4, 6 AND 8
Ticket No at CD R5, 7 AND9
Buy indicator at CB R3
Value at CL R 5,7 and9
Sell indicator at CB R14
Australian dollars at CD R 15,17
Ticket No at CD R16,18
Value at CL R16,18
There can be numerous Buy /Sell lines for each Heading ie Australian Dollars so whilst the Heading, ticket no. and value are always on the same place ie Heading and ticket no always on same column and 1 line below each other and the value is always on the same line as the ticket no. the Buy/Sell whilst always on Col B is always 1 row above the first transaction heading for each different heading on the report , so one Buy or Sell cell for numerous transaction lines.
Just a note This is just part of a 6000 plus lines data sheet
Can anyone see a simple ? solution
Thanks
Rick
I have a spreadsheet from an external source that I need to sort so that we can use the data to create a summary report.
We need to show the data with column headings Name eg Australian dollars, Ticket No, Buy, Sell ,Value for each.
The problem is the spreadsheet we receive has
Australian Dollars at CD R4, 6 AND 8
Ticket No at CD R5, 7 AND9
Buy indicator at CB R3
Value at CL R 5,7 and9
Sell indicator at CB R14
Australian dollars at CD R 15,17
Ticket No at CD R16,18
Value at CL R16,18
There can be numerous Buy /Sell lines for each Heading ie Australian Dollars so whilst the Heading, ticket no. and value are always on the same place ie Heading and ticket no always on same column and 1 line below each other and the value is always on the same line as the ticket no. the Buy/Sell whilst always on Col B is always 1 row above the first transaction heading for each different heading on the report , so one Buy or Sell cell for numerous transaction lines.
Just a note This is just part of a 6000 plus lines data sheet
Can anyone see a simple ? solution
Thanks
Rick