| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Table problem
I have table with month wise data for 3 years in column,s & data in row.
I have a cell out side the table were I will specifiy the date (month-year). I want the data to be deleted from 1st month to month specified above and move cells left and populate the right cells with "0". Thanks Raj |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Table problem
You will need a macro to do this, but you will need to specify far
more details about your sheet, layout and data ranges etc before anyone would attempt it. Pete On Apr 18, 11:43*pm, WRC wrote: I have table with month wise data for 3 years in column,s & data in row. I have a cell out side the table were I will specifiy the date (month-year). I want the data to be deleted from 1st month to month specified above and move cells left and populate the right cells with "0". Thanks Raj |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table problem | Excel Discussion (Misc queries) | |||
| Pivot Table in Excel 2007 : Problem with % in Table | Excel Discussion (Misc queries) | |||
| look up table problem | Excel Worksheet Functions | |||
| league table problem | Excel Discussion (Misc queries) | |||
| Pivot table problem... | Excel Worksheet Functions | |||
Hybrid Mode
