| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sales pipeline follow up
Is it not possible?
"Pascale" wrote: This copy would not work it has to be some sort of programming because when the file comes back, opportunities have mooved around and some have disapeard (Won deals losat deals, revenue expension ect. I would like to unload the file to give you an idea of what i need but I dont know how .... "Billy Liddel" wrote: Pascale You could use 2 macros, one to copy column N to a tempory sheet and another to copy it back. Perhaps these will be ok. The code assumes that you are in sheet3 change this as neccessary. Sub CopyFS() Dim SheetName Dim lastRow As Long, col As Integer, nshts 'make sure you are at the right sheet Sheets("Sheet3").Select 'Change if required lastRow = Cells.SpecialCells(xlCellTypeLastCell).Row col = 14 'column N SheetName = ActiveSheet.Name ActiveWorkbook.Sheets.Add after:=Worksheets(Worksheets.Count) ActiveSheet.Name = "Temp" Sheets(SheetName).Select ActiveSheet.Range(Cells(1, 14), Cells(lastRow, 14)).Copy _ Destination:=Worksheets("Temp").Range("A1") End Sub Sub ReplaceFS() Dim lastRow As Long, col As Integer, nshts Application.DisplayAlerts = False Sheets("Temp").Activate lastRow = Cells.SpecialCells(xlCellTypeLastCell).Row col = 14 Range(Cells(1, 1), Cells(lastRow, 1)).Copy _ Destination:=Worksheets("Sheet3").Range("N1") Sheets("Sheet3").Select 'Change sheet3 if required Worksheets("Temp").Delete Application.DisplayAlerts = True End Sub In Excel press F11, Insert Module and copy the code. Return to excel and run the macro Alt + F8 select the CopyFS to copy to sheet Temp. Don't you add this sheet ReplaceFS copies the data in sheet Temp to column N sheet3. "Pascale" wrote: Hi, I wiuld like to keep track of my F ans S's (Forecastes and stretch deals form week to week. Let me explain: I get a pipeline from an internal explorer, that gets put into an Excel spreadsheet. On that spreadsheet I put f and s in the column N of a sheet called quebec detailed pipeline. This gets transfered into another sheet with a bloq for forecasted opptys ans stretched opptys. So I would need to create a formula so that the following week, when I get to new extract, I can bring back those f AND S ( i CAN MAYBE SEND YOU THE FILE WITH NO ACTUAL DETAILS.) lET ME KNOW IF THAT WOULD HELP |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sales Pipeline | Excel Discussion (Misc queries) | |||
| Sales Funnel Chart or Pipeline | Charts and Charting in Excel | |||
| Chart : Sales Funnel or Sales Pipeline | Charts and Charting in Excel | |||
| how do I customize product sales pipeline management template | Excel Worksheet Functions | |||
| how do I set up a sales pipeline spreadsheet? | Excel Discussion (Misc queries) | |||
Threaded Mode
