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