Sales pipeline follow up

[Pascale]

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

 

[Billy Liddel]

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]

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


.....

 

[Pascale]

Is it not possible?

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


....