Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy non blank cells from 1 sheet to multuiple sheets
Help, I have a register on sheet 1 (Master Sheet) containing in column B
Location which is selected from a list, column C Client Name, column D is either blank or contains an X, my problem is i have 4 sheets one for each Location, every week the Master sheet is updated and i need the cells containing data to be copied into the relevant Location sheets. example; South Peter West Toby X North Jenny East Steve West Donna X North Jerry I need Client in South to be copied over to Sheet South along with the X if entered, and i need this in a way that there are no blank rows between the clients on each sheet, hope i made the request clear if not i may be able to show an example of what i need to do, Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Sheet to new Sheet and clear cells on original sheets | Excel Discussion (Misc queries) | |||
copy a formula down up to blank cells from other sheet | Excel Programming | |||
sheet tabs on multuiple rows | Setting up and Configuration of Excel | |||
Auto "copy and paste" individual cells from various sheets into one sheet ?? | Excel Discussion (Misc queries) | |||
in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet? | Excel Worksheet Functions |