Microsoft Excel Help!?

Question

Hello, I need some help working out of microsoft excel 2007.

I need to know how to pull information from my "data dump" sheet, which can have up to 15000 cells. I need to pull information out of each column every 35 rows to be displayed on another sheet. For example, I need the information from B1, B36, B71, etc, all the way to 15,000. However, I'll also need the information out of B3, B38, B73, etc, these to be displayed on another column in my new sheet. I was thinking conditional formatting perhaps? I'm a little bit of a newbie to excel, so all the help you can provide would be great. If you have time I'd love to be able to email someone who is excel savy with some more questions.

Thank so much!

Answer 1

Here is a simple method to do as you as simply by double clicking any cell in your data sheet whenever you wish to create a new extract on Sheet2.



If you wish to use a different sheet than Sheet2, change the three "Sheet2" references to your actual sheet name, i.e. "Extract", "Sheet4", etc.



Copy the following event handler to the clipboard:



Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

Dim i, LastRow

LastRow = Range("B" & Rows.Count).End(xlUp).Row

Sheets("Sheet2").Columns("A:B"). ClearContents

For i = 1 To LastRow Step 35

Cells(i, "B").Copy Destination:=Sheets("Sheet2"). Range("A" & Rows.Count).End(xlUp). _

Offset(1)

Next

For i = 3 To LastRow Step 35

Cells(i, "B").Copy Destination:=Sheets("Sheet2"). Range("B" & Rows.Count).End(xlUp). _

Offset(1)

Next

End Sub



Select the data worksheet and right click the sheet tab at the bottom.



Select 'View Code'.



Paste the event handler into the white editing area to the right.



Close the VBE and return to the worksheet.



Double click any cell to extract the data.

Answer 2

On sheet 2 in A1 enter 1. Click on Home Tab, Fill, Series, Column, step value 35 end value 15,000



In B1 of sheet2 enter this:



=INDIRECT("sheet1!B"&A1) and copy down the length of the data. This will extract the data from Sheet 1 B1, B36, B71 etc.



In sheet2 C1 enter 3. Click on the Home Tab, Fill, Series, column, step value 35, stop value 15000 click OK.



In sheet 2 D1 enter: =INDIRECT("sheet1!B"&C1) and copy down the length of the data.



This will extract from sheet1 the values from B3, B38, B73 etc.



Make changes to suit where you want the information to be on sheet 2

Answer 3

Lemme bet, you are in a Computer Literacy elegance... might be with the Art Institute??? Because whats humorous is that is the EXACT query of this weeks first challenge. bizarre. "Week three: Week three - W3: Assignment one million Discussion Discussion Question three Compare Microsoft Word, Microsoft Excel, and Microsoft PowerPoint. When will have to you employ every of those packages? When are you able to use those packages interchangeably? Give examples and factors to aid your reply."

Answer 4

Hi.



On your 2nd sheet, use this in A1:



=Sheet1!B1



Then in A2 and copied down as far as you need:



=OFFSET(Sheet1!$A$1, (ROW(Sheet1!$A2)*35), 0)



Now in B1, enter



=Sheet1!B3



In B2 and copied down as far as you need:



=OFFSET(Sheet1!$B$1, (ROW(Sheet1!$B1)*35)+2, 0)



Change "Sheet1" to whatever the name of the sheet is with your 15k rows.