| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
import txt create sheet name
I was wondering if it is possible to have a Macro that looks down a worksheet
for a particular date that uses a cell on another worksheet as reference and then creates a new worksheet with the name automatically changed to the same cell reference. (i.e. dates work completed in column A Worksheet1 but I want to sepearte all work carried out on 01/05/2005 which is a date in C2 Worksheet2 and copy these to a new worksheet named according to C2 Worksheet2. The cell contents could be changed each time before the macro is run. Please can someone stop my nightmare! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create tally sheet for positions- insert names and tally # | Excel Discussion (Misc queries) | |||
| how to create a new sheet with today's date | Excel Discussion (Misc queries) | |||
| Data Import from one sheet to other | Excel Discussion (Misc queries) | |||
| How to create an expandable menu on the left of the sheet? | Excel Discussion (Misc queries) | |||
| Create a sheet name, won't let me, says already sheet named that | Excel Worksheet Functions | |||
Threaded Mode
