| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Worksheet Copy Search Help
Kind of wondering if this is possible. Im new to the excel programming
a little. It throws me an error on the line where i try to look onto another sheet. any ideas For i = 1 To Worksheets("By Store").Cells.Count If Worksheets("By Store").Cells(i, column).Value = cboRefine Then For z = 1 To 13 Worksheets("Results").Cells(i, z).Value = Worksheets("By Store").Cells(i, z).Value Next End If Next |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Worksheet Copy Search Help
Dim Var1 as string
For i = 1 To Worksheets("By Store").Cells.Count If Worksheets("By Store").Cells(i, column).Value = cboRefine Then For z = 1 To 13 Var1 = Cells(i,z).value Sheets("Results").Activate Worksheets("Results").Cells(i, z).Value = Var1 Sheets("By Store").Activate Next End If Next HTH Die_Another_Day Brandon Johnson wrote: Kind of wondering if this is possible. Im new to the excel programming a little. It throws me an error on the line where i try to look onto another sheet. any ideas For i = 1 To Worksheets("By Store").Cells.Count If Worksheets("By Store").Cells(i, column).Value = cboRefine Then For z = 1 To 13 Worksheets("Results").Cells(i, z).Value = Worksheets("By Store").Cells(i, z).Value Next End If Next |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Worksheet Copy Search Help
on the line:
If Worksheets("By Store").Cells(i, column).Value = cboRefine you haven't defined what "column" is. "Brandon Johnson" wrote: Kind of wondering if this is possible. Im new to the excel programming a little. It throws me an error on the line where i try to look onto another sheet. any ideas For i = 1 To Worksheets("By Store").Cells.Count If Worksheets("By Store").Cells(i, column).Value = cboRefine Then For z = 1 To 13 Worksheets("Results").Cells(i, z).Value = Worksheets("By Store").Cells(i, z).Value Next End If Next |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Worksheet Copy Search Help
ok everything worked everyone. thankyou so much
Charlie wrote: on the line: If Worksheets("By Store").Cells(i, column).Value = cboRefine you haven't defined what "column" is. "Brandon Johnson" wrote: Kind of wondering if this is possible. Im new to the excel programming a little. It throws me an error on the line where i try to look onto another sheet. any ideas For i = 1 To Worksheets("By Store").Cells.Count If Worksheets("By Store").Cells(i, column).Value = cboRefine Then For z = 1 To 13 Worksheets("Results").Cells(i, z).Value = Worksheets("By Store").Cells(i, z).Value Next End If Next |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I search for a .bmp in a worksheet using VBA in Excel | Excel Programming | |||
| Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
| Search and Copy within Excel using VBA | Excel Programming | |||
| Create a search Field within a worksheet to search command buttons | Excel Programming | |||
| Excel Copy/Search/Paste Help Needed ASAP! | Excel Programming | |||
Hybrid Mode
