Macro To Update Links In Active Sheet Only
I have a workbook which has links to another excel workbook (source). This workbook has many sheets -all exact copy- with different names. I changed startup prompt (edit->links) to "dont display the alert and dont update automatic links". Then I recorded a macro for updating links (from source) and assigned this macro to a button. What I want to do is when I click this update button I want links to be updated only on the active sheet that Im on. My problem is, when I press this button, it updates all links including other sheets (basically whole workbook).
My current macro is (I dont know coding but I tried changing ActiveWorkbook to ActiveSheet but it didnt work):
Sub update()
ActiveWorkbook.UpdateLink Name:= _
"C:Documents and SettingsAlperDesktopExcelsource.xls", Type _
:=xlExcelLinks
End Sub
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Update Links Only Via Macro Code
I have a 15 excel files which are part of the forecast system. There is another file MASTER which is the host file for the macro. Every months multiple users are asked to update their forecast in the 15 excel files .As these files also display actuals, so they are linked to bunch of other files. The links to the files should not be updated unless I run my macro from MASTER to do the series of tasks. Everytime these users open the files , they are asked to update links. Is there a way for me to stop this warning and still able to update the links only when i run my macro from the Master.
View Replies!
View Related
Update Links And Click Update, Returns #VALUE!
I have a vlookup to another workbook. It works fine if both workbooks are open. But if both are not open and I open the workbook with the links and click Update, #VALUE! returns. I have attached the two files. I don't think it is my formula, but here it is anyway. =IF( COUNTIF([Tempozgrid.xls]June!$A$52:$A$83,A3),VLOOKUP(A3,[Tempozgrid.xls]June!$A$52:$L$82,12,FALSE),0)
View Replies!
View Related
Macro Copy Of The Active Sheet And Then Rename The New Copied Sheet
I'm trying to create a copy of the active sheet and then rename the new copied sheet to what's in cell O4, which is a formula (see below) and then paste value cell O4 in B3 of the copied sheet. However, when I run this macro it doesn't seem to like the second line where I am renaming the sheet (run time error '1004'). "O4" =DATE(YEAR($B$3),MONTH($B$3)+1,DAY($B$3)) Sub NewMonth() ActiveSheet.Copy Before:=Sheets(Sheets.Count) ActiveSheet.Name = Range("O4").Value ActiveSheet.Range("O4").Copy ActiveSheet.Range("B3").PasteSpecial Paste:=xlPasteValues End Sub
View Replies!
View Related
Update Links Across Workbooks
I have a Vlookup in a shared workbook looking in another shared workbook for the data I want. I open the file and click "Update Links" but I then get the following message box: "This workbook contains one or more links that cannot be updated. -To change the source of links, or attempt to update values again, click Edit Links. -To open the workbook as is, click Continue. I know this message is trying to tell me it can't find my links, but the path/workbook/ sheet are correct and the numbers are getting updated. I'm worried the message will deter the other users of this workbook from allowing the use of the vlookup.
View Replies!
View Related
Update Formula Links
I have a sheet with formula in various cells that are referenced to a sheet that doesnt initially exist. For example one formula on the sheet is: =If( 'WF Tracker 2008'!$D$5=AN$4,INDEX('WF Tracker 2008'!$B$6:$P$10, MATCH($E36,'WF Tracker 2008'!$B$6:$B$10,), MATCH(AN$7,'WF Tracker 2008'!$B$6:$P$6,)),IF(AN26="N/A",AN31,"N/A")) and initially, sheet 'WF Tracker 2008' doesnt exist so the formulas all produce #ref! values which I expect. My problem is that I Run a macro that creates the sheet 'WF Tracker 2008' but the formula dont want to refresh/update unless I individually go into each cells formula in the formula bar and hit return.
View Replies!
View Related
Update Links To All Spreadsheets
I'm hoping to find a way to update links on all spreadsheets going backwards. ie. s/sh 5 is linked to s/sh 4 s/sh 4 is linked to s/sh 3 s/sh 3 is linked to s/sh 2 s/sh 2 is linked to s/sh 1 Is there a way of opening s/sh 5, and having it automatically update s/sh's 2,3 and 4 (1 has no links), rather than just updating s/sh 4, as would be the normal functionality. Currently I need to open 2, then 3, then 4, otherwise changes to s/sh 1 do not flow all the way through to s/sh 5.
View Replies!
View Related
Update Links Without Prompt
I'm using code which forces users to enable macros prior to being allowed into a file. Then I ran into an issue of needing this Shared Workbook to update links, which you can't do in the workbook_open event and I do not want users prompted to update or not. So what I've done is made a 'skeleton' file to force the macro enable and then open up the real file with updated links. Once the real file is opened I want that skeleton file to close. For some reason, once the file closes the code halts. "Forcemacroenablemaster" closes, but nothing runs after it. If I comment the close line out everything after runs. This code is in my "Forcemacroenable" file: Private Sub Workbook_Open() Call ShowAllSheets Workbooks("Forcemacroenablemaster.xls").Close False MsgBox "Test" Call ValidSetup frmCtrlPnl.Show End Sub
View Replies!
View Related
Update Links Object
I have a macro that creates links to another workbook and then changes the setting for the links update to "xlUpdateLinksNever". I wrote this macro in Excel 2003. I am now testing across different excel platforms and this errors out when I try to use it in excel 2000. I'm assuming this is because excel 2000 does not have the same ability to ontrol the links.
View Replies!
View Related
Warning Message When I Update Links
I have this problem: I have a workbook with a formula liniking to another workbook. When I open the workbook, I click on "update links" and then I get this warning message: "The workbook contains one or more (than one) links that cannot be updated. * To modify the origin of links, or to look up to update the values again, choose Modify links * To open the workbook as it is currently , choose To Continue" I cannot understand where is the problem, the link is updated, state of link is "ok", I even can open the origin from Modifiy menu --> link --> open origin
View Replies!
View Related
Turn Off Alert: Update Links
This code only opens and closes a number of files found in a single folder. Sub test2() ' opens and closes all files in a folder Dim Mypath As Variant Dim excelfile As Variant Mypath = "W:A Construction2006FinancialPrivateInternal Monthly ReportsSeptember 2006" excelfile = Dir(Mypath & "*.xls") Application.DisplayAlerts = False Do While excelfile <> "" Set wbOpen = Workbooks.Open(Filename:=Mypath & excelfile) excelfile = Dir MsgBox excelfile wbOpen.Close Loop Application.DisplayAlerts = True End Sub I am getting Update/Don't Update Links from those files requiring same that I wish not to receive even though I am using Application.Display. Alerts code above.
View Replies!
View Related
Suppress Update Links Message
I have a template workbook which contains link to information in another workbook. I open this external workbook by GetObject method. Private Sub Workbook_Open() Dim MyObject As Workbook Set MyObject = GetObject("C:data.xls") End Sub And I would like to get rid of this window (I don't want to update that information until the external file is open)
View Replies!
View Related
Show Message While Links Update
Is it possible to display a dialog box or msgbox that doesnt have an OK button ? i.e I want a message that comes up on the screen that says "Links Updating...Please Wait" which then automatically changes to "Links Sucessfully Updated" on completion...I dont want the macro to be interrupted by the msgbox/dialog....
View Replies!
View Related
Disable Update Links Message
I have tried using the following in the ThisWorkbook Module which does not seem to work because it appears the "Update Links" message fires before the Open Event Private Sub Workbook_Open() Application.AskToUpdateLinks = False End Sub I know it is possible to turn it off manually through Tools-Options but have 30 users and do not want them seeing the "Update Links" message if possible to turn it off.
View Replies!
View Related
My Links Dont Update All The Time
Sub unprotectEm() ActiveSheet. Unprotect Password:="shreked" ActiveWorkbook.UpdateLink Name:="R:SHAREDPASSACCEXCELPASSACCCONTROL.XLS" _ , Type:=xlExcelLinks ActiveSheet.Protect Password:="shreked" End Sub Private Sub Workbook_Open() If ThisWorkbook.ReadOnly = True Then MsgBox "READ ONLY YOUVE BEEN WARNED" End Sub It works fine until its been opened as "read only". What I mean is I open the file and the read only msg box comes up no prob. When the file avail for editing again I open the file and its not updating the control list.
View Replies!
View Related
Update Of Links In Formula For All Cells
I have cells (range named Formulas) in a worksheet A (wsA) linking to another workbook. This workbook has several sheets, each a different forecast. From a Radio Button Group on wsA I would like to choose forecast, FC1-FC3, and then all the cells in the range Formulas would be updated with the choosen FC. I would like a VBA script to handle this:When the workbook is activated the present Forecast in the Radio Button Group should be stored as a variable (oldFC)When I choose a new forecast, the value should be stored in a new variable (newFC)I then want to loop through the whole range (Formulas) and update each cell and it's part of string value to the newFC Before update: wsA cell N3='H:[5500-plan-06.xls]FC 3'!N$16 wsA cell N4='H:[5500-plan-06.xls]FC 3'!N$17 When new Forecast is choosen this should be update to: wsA cell N3='H:[5500-plan-06.xls]FC 1'!N$16 wsA cell N4='H:[5500-plan-06.xls]FC 1'!N$17
View Replies!
View Related
Slow Update Of Edited Links
My business has a significant number of Excel sheets interlinked. One of them has about 10.000 links to about 60 files. Those 60 files are within a sub-folder and once a quarter the business needs to replace all 60 files with a new set. To establish this, they replace the sub-folder name in the link with the new name. To do this on 10.000 links takes about 72 minutes because Excel seems to open up a file for every updated cell. We tried to stop this by changing Excel to calculate manual, disabled "Update remote reference", but this didn't improve anything. We have similiar issue when opening/updating the master file - it takes around 3 mins. Besides that a proper database is certainly better for this requirement, is there anything we can do to improve the performance of the replace method. I was thnking about stopping Excel from validating/updating each single cell and after everything has been replaced to do it in one go without Excel opening and closing 10.000 times a file.
View Replies!
View Related
How To Update Master Workbook With Links To Other Workbooks
I have a workbook that links out to numerous other workbooks for current data. After one of the supporting workbooks gets up dated, I return to the master workbook. Here, I need to see the updated results. The only way that I can find a way of updating the master is to close and save it and then re-open. Is there a way of updating the master workbook using a macro?
View Replies!
View Related
Color Cells With External Links On Update
I have the following code in Sheet1 for file Book7.xls Private Sub Worksheet_Calculate() On Error Resume Next For Each rcell In Range("A1:D6") Select Case rcell.Value Case Is >= 5 rcell.Interior.Color = vbBlue Case Is < 5 rcell.Interior.Color = vbRed End Select Next rcell End Sub Range A1:D6 is linked to an external source file which I am changing every now and then. A1 has the formula: =[Book8.xls]Sheet1!A1*1 Copied all the way to D6. [Book8.xls]Sheet1!A1:D6 presently has all values 1 hence the formatting in Book7 is all red. Now I an changing source file to Book9.xls (thru EDIT menu->LINKS). [Book9.xls]Sheet1!A1:D6 has all values 10. But when I change external source to Book9.xls, the right formatting did not apply. All are still red (instead of blue). I still need to go in one of the cell and press F2 and F9 to trigger calculation. How do I change the code in order to recognise the calculation in order to trigger the codes in the event?
View Replies!
View Related
Auto Update Links With Current Values
When copying data from a closed workbook, I frequently get the prompt: "Links to 'Source.xls' were not updated because 'Source.xls' was not recalculated before it was last saved. To update links with current values in 'Source.xls', click OK..." Is there a way I can bypass this prompt and automatically update with the saved (uncalculated) values and therefore not require a user intervention?
View Replies!
View Related
Cell Formula: All The Links To Update Automatically
I am linking to cells on a spreadsheet and in some cases the formula is showing in the cell and in others the contents of the linked cell. I have forced updating (F9 )and F2 enter with no effect. Is their something i am missing as I want all the links to update automatically. If I copy and paste a working formula into one of these cells it updates albeit with the wrong reference but if i go in and edit F2 etc then it shows as a formula.
View Replies!
View Related
How To Run Macro From Active Sheet
I have written the below macro to copy data from a sheet called "Fixit Example 1" to a sheet called "Fixit Summary Example". It works fine, but I'd like to be able to run it from any "Fixit Example XX" worksheet. As written, the data is always copied from "Fixit Example 1" regardless of what worksheet I have open. I tried replacing Windows("Fixit Example 1.xls").Activate with Windows(Active.Worksheet).Activate but got an error "Run time error 424. Object required." Sub MoveData() ' ' MoveData Macro ' Macro recorded 18/03/2009
View Replies!
View Related
Open Workbook With Password & Update Links
I am having a workbook in server, it consists more than 12 sheets. Everyday in the early morning it need to be get updated, (i.e) normally when i open the file, it as for the Password (password for workbook), then after I given it will show three buttons Update Don't Update Help, so i need to press the Update Button , it should be done everyday in the early moring. Is there any way to do this automatically open and update and close everday through vba code or anyother ways.
View Replies!
View Related
Update Links Opening Workbook: Turning Off Warnings
When ever I open a file a message comes up reading "This workbook contains links to other data sources" and then asks me wethere I wasnt to update or not. Well I don't want people to see this when they run a Macro I have created. So what I would like to know is if there is some code that I can add into the macro that will either disable that message or somehow always answer "dont update" everytime that message comes up so that the user wont have to be bothered with it.
View Replies!
View Related
Don't Update Links On Workbook Open
I have a workbook that has many cells that link to a server on the other side of the planet. If I manually open this workbook I get the "This workbook contains links to other data sources." And the option to "Update" or "Don't Update" If I choose to not update, everything works great. If I choose to update, the worksheet takes 10-15 minutes to open. I have tried to go to tools-->options-->Edit and uncheck "ask to update automatic links" but this makes the default behavior updating. I want to open this workbook using a scheduled task and a batch file, and have it not update, and then run a macro. Any suggestions on how to do this?
View Replies!
View Related
Automatically Update External Links To Csv File In 2007
I have an Excel 2003 workbook (named TargetWorkbook.xls) with some links to a CSV file called DataSource.csv. I use Excel 2007 to open the workbook. I checked the "Update links to other documents" option under the "When Calculating this workbook..." section on the Advanced pane of the Excel Options window. I unchecked the "Ask to update automatic links" option under the "General" section on the Advanced pane of the Excel Options window. I selected the "Don't display the alert and update links" option on the Startup Prompt dialog (accessed from the Edit Links dialog) I created a simple Auto_Open macro with the following statements: Sub Auto_Open() Workbooks.Open Filename:="C:ProjectsExcelTestDataSource.csv", ReadOnly:=True Worksheets("DataSource").Activate Workbooks("TargetWorkbook.xls").Activate Windows("DataSource.csv").Visible = xlVeryHiidden End Sub The DataSource.csv file is updated daily. I want the cells of TargetWorkbook.xls to automatically update from the csv file when I open TargetWorkbooks.xls without displaying a prompt. I plan to deploy this workbook to a server and open it programatically via a Windows Service (I know, I know, Microsoft doesn't encourage this)and can't have it throwing up a user dialog. Here is the problem: When I open TargetWorkbook.xls manually using Excel 2007, it updates the links but throws up the dialog "This workbook contains one or more links that cannot be updated...". When I click on the "Edit Links..." button, it displays the message "Warning: Open source to update values". When I click the "Check status" button for this link, it says "Source is open". How do I prevent this dialog box from poping up? I've been wrestling with this for a few days now and can't find a solution.
View Replies!
View Related
Advanced Filter Active Sheet Macro Code
the macro mentioned below has been assigned to a combo-box form. I have 2 different datasets in the same sheet, they have the same headers (but named differently, myhead and myhead1) and the same adv filter criteria range (named as "dcrit") is applicable to both datasets. So, if an item is selected from the combo-box, both the datasets should get filtered according to same criteria. how i can combine the 2 IF LOOPS mentioned in the code? Sub myfilt() Application. ScreenUpdating = False If ActiveSheet.FilterMode Then ActiveSheet.ShowAllData If Not (Range("indsignal")) Or Not (Range("countsignal")) Then Range(Range("myhead"), Range("myhead").Offset(1, 0).End(xlDown)).AdvancedFilter _ Action:=xlFilterInPlace, CriteriaRange:=Range("dcrit"), Unique:=False End If If Not (Range("indsignal")) Or Not (Range("countsignal")) Then Range(Range("myhead1"), Range("myhead1").Offset(1, 0).End(xlDown)).AdvancedFilter _ Action:=xlFilterInPlace, CriteriaRange:=Range("dcrit"), Unique:=False End If Application.CutCopyMode = False Application.ScreenUpdating = True End Sub
View Replies!
View Related
Create Macro To Chart Data With Location As Object In Active Sheet
I have been trying to create a macro in excel to chart a selection of data and to output the chart on the active sheet where the data was taken (as opposed to a named sheet). So basically, I have about 300 worksheets with data, and I would like to have a button on each page that automatically charts that data when clicked, and outputs the chart to the page where the macro was clicked. However, I have not been able to figure out a relative reference that will allow me to make the LocationasObject reference simply the ActiveSheet as opposed to a specifically named sheet. See my code below, which references an output to a worksheet called "Charts". Right now, all of my charts are outputting to the sheet called "Charts", as opposed to the active sheet. Sub ConsDiscChart() ActiveCell.Offset(29, 11).Range("A1").Select Selection.End(xlToLeft).Select Selection.End(xlToLeft).Select Selection.End(xlToLeft).Select Selection.End(xlToLeft).Select Selection.End(xlToLeft).Select Selection.End(xlToLeft).Select Selection.End(xlUp).Select Selection.End(xlUp).Select Selection.End(xlUp).Select Selection.End(xlUp).Select Selection.End(xlUp).Select Selection.End(xlUp).Select Selection.End(xlDown).Select ActiveCell.Offset(0, 1).Range("A1:B1").Select Range(Selection, Selection.End(xlDown)).Select ActiveCell.Offset(0, -1).Range("A1:C24").Select Charts.Add ActiveChart.ChartType = xlLineMarkers ActiveChart.Location Where:=xlLocationAsObject, Name:="Charts" With ActiveChart .HasTitle = False .Axes(xlCategory, xlPrimary).HasTitle = False .Axes(xlValue, xlPrimary).HasTitle = False End With End Sub
View Replies!
View Related
Do Not Update Non-active Sheets
I have a big spreadsheet with a number of sheets, some with dynamic lists which take up a lot of processing power, but which I only use rarely. Consequently the whole spreadsheet is running very slowly. Is there a way to set certain sheets to not automatically update, but retain automatic updating on others? I know you can set Calculation to Manual in the Options, but I need to retain automatic calculation on some sheets.
View Replies!
View Related
Office 2007 - Where Has The 'do You Want To Update Links' Box Gone
I'm opening an Excel file that automatically attempts to update links when I open it, but I am not prompted with the choice to cancel, or update links, when I open the file, like I was in Office 2003. I have checked the Excel Options, Advanced, General, 'Ask to update automatic links' box, but I still don't get the dialog box when I open the file. The file is just riddled with VALUE errors. A colleague of mine who opens the file in Office 2003 can see all the data fine.
View Replies!
View Related
Keep Hidden Sheet Made Visible As Active Sheet
I have a button on a sheet that runs a macro to unhide another sheet. That works, but I want the sheet made visible to remain forward. Instead, the button unhides the sheet and the sheet the button is on comes forward again. I am unable to figure how to keep the sheet made visible forward. Here is the macro 'as recorded'. Sub UnhideSheet1() Sheet2.Visible = True End Sub
View Replies!
View Related
Transpose Links From Individual Sheets To Master Sheet
I have multiple sheets on which users enter data in Cells B3 to B21 on each sheet. I have a master sheet where the information entered on individual sheets is copied by links. On the master sheet the information is displayed in Rows. Thus data on Sheet1 B5:B25 is displayed in Row 6 cells H6:Z6 of Master Sheet, data on Sheet2 is displayed in Row 7 cells H7:Z7 etc. The formula in H6 of the Master Sheet is =Sheet1!B5, in H7 it is =Sheet2!B5 etc. It is of course not possible to use Autofill to copy formulas across on the Master sheet. It can be done manually but there are hundreds of cells to fill. Is there an elegant way to copy the formulae on individual sheets onto the Master Sheet. I want to be able to repeat the procedure later if additional sheets need to be added.
View Replies!
View Related
Process To Remove Background Links From Entire Sheet
I have a spreadsheet that was given to me from an outside source, and a lot but not all of the cells (seem to be random) have links associated with them so that if you click a cell, it opens a new internet browser window directing to the link. Is there a way for me to remove every single one of these links without having to go cell by cell looking for each one ?
View Replies!
View Related
Copy/Paste From Active Sheet To Another Sheet
I want to copy data from the current sheet, and past it in the "montly" sheet. 'i and j were defined above, with a Case statement Range(" Ai:Cj").Select Selection.Copy Sheets("monthly").Select ' I want the upper left cell of the pasted area to be A11 Range("A11").Select ActiveSheet.Paste I get an error saying that I should select one cell and then paste. But I thought that that is what I did...
View Replies!
View Related
Macro For Updating Links
if it was possible to write a macro that will update a link to a file that has the same file name but now lies in a different folder/directory path. I have about 50 spreadsheets that link to this file which has now been moved.
View Replies!
View Related
Update Data By Ado - Change/delete Data And Then Run Macro For Update Data In Source Spreadsheet
I have one source spreadsheet, where are columns NAME, DATE. I read these data by ADO to other spreadsheet, where I can change/delete data and then run macro for update data in source spreadsheet. The problem: In source spreadsheet is column "NAME" and column "DATE", with values e.g. "Joseph"; 1.1.1980. I read this data to other spreadsheet, then I delete in it value 1.1.1980. When I run macro Update, it messages error. Sub UpdateItem ... .Fields.Item(1).value = activecell 'activecell value = "Joseph" If Not isempty(activecell.offset(0,1)) Then .Fields.Item(2).value = activecell.offset(0,1).value Else .Fields.Item(2).value = "" 'I tried Empty and 0 too but when I read data again then, it displays 0.1.1900, nothing works End If ... End Sub It seems that in source spreadsheet has data in column "Date" format Date and when I try to update data in format String ("") in source spreadsheet by Update macro, it messages error. When I used .Fields.Item(2).Value = Empty ' or .Fields.Item(2).Value = 0 after rereading data it displays 0.1.1900 What I want to get is that if the cell with date (in other spreadsheet) is empty, the cell in column Date in source spreadsheet after updating will be blank (contains no values).
View Replies!
View Related
Macro Automatically Clicking Links In Cells
I have a list of links in 1 excel worksheet. They are spaced every other row if it makes a difference. I need to create a macro that clicks on every link automatically. Each link is a direct file that I need downloaded every few months. I have no Macro experience beyond hitting record to automate basic tasks.
View Replies!
View Related
Macro Where I Try To Edit The Links After I Open The Workbook
I have a macro where I try to edit the links after I open the workbook. I used the macro recorder to get the code, and if I use it, it works great. However, when I try to insert some variables in the code, I get an error saying "Method 'ChangeLink' of object'_Workbook' failed. I don't know why I'm getting this error. Below is code. Sub MyCode Dim VarianceMonth As Variant VarianceMonth = VarianceReport.cboMonth.ListIndex + 1 Windows(VarianceMonth & "_2007 Forecast (LGBU).xls").Activate ActiveWorkbook.ChangeLink Name:= _ "\sf1d3shareLGBU_ FinanceAdministrative ReportsMonthly Forecasts" & VarianceMonth & "_2007" & VarianceMonth - 1 & "_2007 Forecast (Ancillary).xls" _ , NewName:= _ "\sf1d3shareLGBU_ FinanceAdministrative ReportsMonthly Forecasts" & VarianceMonth & "_2007" & variancmeonth & "_2007 Forecast (Ancillary).xls" _ , Type:=xlExcelLinks
View Replies!
View Related
Stop Links Updating Opening Workbook With Macro
Currently I am using VBA Code below to Stop Update links prompts Private Sub Workbook_Open() Workbooks.Open "C:TempBook2.xls", UpdateLinks:=False End Sub Is there code I can use such This Workbook so that I can save this file as another name and it will work? Biz Auto Merged Post;Dear All, I have found VBA code that works. Private Sub Workbook_Open() Workbooks.Open ThisWorkbook.Name, UpdateLinks:=False End Sub
View Replies!
View Related
Linking Cells For Update On One Sheet It Updates My Last "customer Touch" On A Master Sheet
I am tracking my sales interactions and am trying to link cells so when I update on one sheet it updates my last "customer touch" on a master sheet. Current formula- On "sheet1" I selected a cell and used this formula... =sheet2!$b$7 The problem is that I want to keep a history of what was in that sheet 2 B7 cell so i insert a row (making B7 move down and become B8) and enter new info into the new b7. if I go back to sheet1 the formula in the selected cell becomes =sheet2!$b$8 I want it to stay to =sheet2!$b$7 no matter what I do... insert rows, delete rows etc... in short what i am trying to do is have a cell in sheet1 show my last interaction with the customer and keep a history of in sheet2-infiniti.... with the caveat that my last interaction on sheet 2 etc... is listed first (thus the insert row)
View Replies!
View Related
Update Sheet From Previous Sheet
what im hoping to do is when i press macro button"click to sort" on sheet totals it will automatically input the totals from "TOTALS" underneath the right name and put the date in column a the trouble is the cells are dependant on the sort so if i was to press "click to sort" now it would transfer this data to sheet "PTS AND DATES" 09/02/09 in cell a2 1146 in b2 861 in c2 860 in d2 849 in e2 806 in f2 the very next time i press it , it will put data into row 3.
View Replies!
View Related
|
TRACKER
