| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to extract data and paste to a new sheet
Could anyone please help
I have what you would call a 'typical' spreadsheet i.e. categories across row 1, dates down column A then a value against certain categories on certain dates. What I'm trying to do is create a macro that extracts the data, the date and and the category to a new work sheet but only where data actually exists. I'm essentially trying to create a data table from the existing worksheet. Regards Les. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 1 Create a macro to Copy & paste certain data to another sheet | Excel Discussion (Misc queries) | |||
| macro to extract data of a selected sheet | Excel Discussion (Misc queries) | |||
| Open Sheet, Run Macro, Extract data | Excel Programming | |||
| Macro 2 Extract Data 2 Paste in New Wksht | Excel Programming | |||
| macro to extract info and paste to a new sheet | Excel Programming | |||
Threaded Mode
