Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Script to conditionally copy data to another sheet?
I have a workbook that I've been extensively automating but unfortunately I'm
still pretty new to VBA. I have a long range of data that I'd like to copy to a new sheet *only when* a particular column contains data. For example, my data range starts in cell B35 of Sheet1 and goes to L301. I'd like to copy only those rows of data when a value has been placed in column E (column E cells are blank by default) to Sheet2. I'd also like the information to port over as values only. Can anyone help me out? Thanks in advance for any and all help!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VB Script to copy incremental data from one sheet of workbook to o | Excel Discussion (Misc queries) | |||
Conditionally copy from multiple sheets to one sheet | Excel Programming | |||
export sheet data for batch script | Excel Programming | |||
Conditionally Fill a sheet row if cell value in another sheet 0 | Excel Worksheet Functions | |||
Excel macro script to copy only formulas and not values from one sheet to another | Excel Programming |