Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
please help, need to copy row to separate spreadsheet in workbook
i have a workbook with several spreadsheets. in each row on each spreadsheet
there is a sku, upc, description, empty cell to enter floor count (we'll call this A), empty cell to enter backroom count (we'll call this B), empty cell to enter system count (we'll call this C), cell that automatically calculates the difference between the system count and the combined totals of floor and backroom counts (D= C-(A+B)). what i need it to do is- if D is more or less than 0, i want that whole ROW copied to a blank spreadsheet at the end of my workbook. so far, i have only been able to get it to copy the first cell from that row, but i need the whole thing. is there a way to do this other than putting a formula in each row in that column??? thanks, i hope i explained this well. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
please help, need to copy row to separate spreadsheet in workbook
CAN ANYONE HELP PLEASE?
if column g is < or 0, i want it to copy that entire row to a spreadsheet in the same workbook. if it =0, i want it to leave it and move onto the next row. is there a way of doin this without puttin a separate formula into each cell? not only is that really really tedious, but then ill end up with blank rows. basically, i need a list of all the skus from several spreadsheets within a workbook that have a variance (column g does not equal zero). this list needs to be its own spreadsheet in the workbook. "nso" wrote: i have a workbook with several spreadsheets. in each row on each spreadsheet there is a sku, upc, description, empty cell to enter floor count (we'll call this A), empty cell to enter backroom count (we'll call this B), empty cell to enter system count (we'll call this C), cell that automatically calculates the difference between the system count and the combined totals of floor and backroom counts (D= C-(A+B)). what i need it to do is- if D is more or less than 0, i want that whole ROW copied to a blank spreadsheet at the end of my workbook. so far, i have only been able to get it to copy the first cell from that row, but i need the whole thing. is there a way to do this other than putting a formula in each row in that column??? thanks, i hope i explained this well. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I separate a large spreadsheet into worksheets? | Excel Worksheet Functions | |||
Range name in separate workbook | Excel Discussion (Misc queries) | |||
How do I copy each row from 1 Worksheet to separate Worksheets? | Excel Discussion (Misc queries) | |||
Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
Issuing macro in workbook from separate workbook | Excel Discussion (Misc queries) |