The Value In The Field Should Not Disappear After Refreshing A File

Apr 6, 2009

I have got this in a pivot table

Customer Total sales(USD)

30010 500.00
30041 2000.00

In another column I enter a comment for customer 30010(and leave the comment column for customer 30041 blank) as below
Data 1.xls
Customer Total sales(USD) Comment

30010 500.00 Test 1
30041 2000.00
Later on the content of the file changes as below:

Customer Total sales(USD)

30025 1500.00
30010 500.00
30041 2000.00
When the file is refreshed I would like to have comment as per the former file i.e the comment “Test 1” should appear against customer 30010 and similarly for any other customer that I enter the comment.It should be as below:
Customer Total sales(USD) Comment

30025 1500.00
30010 500.00 Test 1
Customer Total sales(USD) Comment

30041 2000.00

View 9 Replies


How To Put File Name In Field

Mar 14, 2013

after macro is finished I want to put file name on in field


Range("HPU").Value = fileToSave
fileToSave - it's give me whole path, like: C:DBNewV1Testjan.csv

but I want to have just name of the csv (jan.csv).

How can I del the rest?

View 3 Replies View Related

Excel File To Automatically Read Date & Pre-populate From 1st Field

Aug 13, 2014

i have a file that needs to have daily postings to it, I would like for it to automatically generate today's date and then if you change figure 1, it carries over to figure 2.

View 3 Replies View Related

Excel 2010 :: Creating Mandatory Field Before Saving A File?

Aug 22, 2013

coding mandatory field in Excel 2010.

This is a code that i have for having a master workbook, and saving it in different folder so my employee cant access it

Sub NextInvoice()
Range("J2").Value = Range("J2").Value + 1
Range("E6:E9,H9,J9,B14:K20,H4,B28:K32,B36:B39,D36:D39,F36:F39,B42:K43,B46:K47,B50:K51,B54:K55,B58:K59,B62:K63,B66:K67,B70:K71,B 74:K75,D78:E78").ClearContents
End Sub
Sub SaveInvWithNewName()
Dim NewFN As Variant
'Copy Invoice to a new workbook


I have found a code for mandatory cell, but it creates a second macro and i was not able to link the two.The mandatory field has drop down of employee's and it is located in the cells D78:E78.

View 1 Replies View Related

{} Brackets Disappear

Apr 28, 2009

I have a formula


For instance

This formula works

But when i click in the cell to edit the formula the {} (at the beginning and end) disapear and the formula no longer works.
If i add them back manually the formula still does not work.

How can i edit these formulas without stopping them working.

View 3 Replies View Related

Formula Disappear The Value

Mar 21, 2009

I have a formula in C5 = IF(C$1=$A$2,($J$3-B$4)/COUNTA(C$1:$J$1),"") the problem is, when I will copy the formula in C5 and paste it to D5, E5, F5, G5, H5, I5 & J5 respectively, the value will disappear. What should be my formula in order not to disappear the value?

ABCDEFGHIJ108-Mar-0915-Mar-0922-Mar-0929-Mar-0905-Apr-0912-Apr-0919-Apr-0926-Apr-0903-May-09208-Mar-0914-Mar-0921-Mar-0928-Mar-0904-Apr-0911-Apr-0918-Apr-0925-Apr-0902-May-0909-May-093Planned Cumulative1204Actual Cumulative15Remaining Qty. per Wk14.88

View 9 Replies View Related

Make These Lines Disappear!!

Sep 5, 2008

I have an excel document that looks all nice and pretty except for the little white grids all over it with unused cells. Is there anyway to hide the lines? i dont care that the cells are there just the lines make the form look kinda crappy.

View 4 Replies View Related

Label To Be Visible In Second Then Disappear Again?

Mar 3, 2014

Is it possible in a Label caption to be visibile in a second?

I just want, when the user hit the commandbutton1, a label will be visible in a second and then disappear again after 1 second.

View 4 Replies View Related

What Can Cause A Variable Type To Disappear

Apr 20, 2009

One of my workbooks won't allow me to use the VBE variable types (VBProject, VBComponent, etc.) They aren't on the popup list that appears when I type " as ". If I just type in "VBProject", I get a compile error "User-defined type not defined". I have to define the variable as object, and the macro still works. I do not have this problem in any other workbook.

View 3 Replies View Related

Make The Message Box Disappear

Dec 19, 2006

before i run my macro, i would like a msg box that appears that says "please wait, this may take a while". I've tried using the msgbox function but unless the user presses the "OK" button on it, the macro won't run....

any suggestions on how i can have a userform/msgbox appear while the macro is working in the background (without the user having to press "ok")

View 9 Replies View Related

How To Enter Name On 1 Sheet, Have It Disappear On Another

Sep 1, 2007

I think I asked this in a much more complicated & confusing way before; hoping this makes more sense. I'd like to set something up so that when a name is entered in ColA of sheet1, it disappears from a list of names in ColA of sheet 2.

View 9 Replies View Related

Making Cells Disappear

Nov 20, 2007

Is there a macro that can make cells with no data in them disappear or not be displayed?

View 9 Replies View Related

Buttons Disappear On Some Machines

Nov 9, 2006

In recent weeks, when I've been asked to demonstrate excel applications which make use of buttons, I've found that on some machines the buttons will variably display as flat grey rectangles with no label, or boxes with red 'x's, or alternatively not appear at all. There seems to be no pattern since the variations have all happened on single machines, then not at all on similar machines.

So far it has only been company laptops (not my own machine), hooked up to overhead projectors which end up with this problem. I can't think of anything I would have done manually to disable the buttons from appearing.

Is this a known issue, or is this simply down to the user preferences and/or security settings?

View 7 Replies View Related

Auto Populate Field With Date When Other Field Is Selected From Validation List

Jul 4, 2013

In the following extract, I would like to have today's date placed into Col K when an entry is made into Col J.

Entry into Col J is from a validation list of 3 options. What I desire is that when one of these options is selected ("Complete"), then I would like today's date to be written into Col K.

Currently Col K has a validation list which comprises dates from 1st of each month from July to June.

I need a fixed date as text preferably, so was thinking the VBA function "Date" on a Change Workbook Sub.

The information is currently part of a Table in Excel 2007 that has about 500 records.



Month Completed

In Progress




Data Validation in Spreadsheet

Input 1
Input 2



View 2 Replies View Related

Macro To Preset Field With Text If Condition In Another Field Is True

Jun 9, 2006

I have a macro that imports a report. If the Charge Type in column A is BTOREPLX, I need to prefill the field next to it in column B with the text "REPLX", e.g. "REPLXCDROM". I've attached an example of the report.

View 5 Replies View Related

Change/Move Pivot Table Row Field To Column Field

Apr 23, 2008

In building my pivot table my data that I want to show in the column area is showing up as rows stacked on top of each other. In the column section I'm trying to show Total Budgeted Amount next to Total Actual Amount but on the layout it's showing the two stacked on top of each other is there some kind of hidden key that I'm missing?

View 3 Replies View Related

'vlookup' Not Refreshing

Nov 1, 2008

I have been working with one sheet (call it tab A) that has 40-50 vlookup formulas that reference another sheet (call it prices) within the same workbook. Everything worked fine. I change my prices tab and everything auto changes in tab A.

Now I copied 'tab A' 22 times creating tabs B - W. I need to slightly modify each tab and based on my prices data, print out the appropriate tab.

Problem is now, when I change my pricing tab, tab A - W do not update. F9 does nothing. Rebooted didn't work. If I go into the formula and hit F2 to edit & return it recalculates to the correct data. But I can't get it to auto update.

View 6 Replies View Related

Usedrange Not Refreshing

Oct 12, 2007

I have a worksheet on which i use vba Usedrange to determine all the cells that are being used, but it only picks up all the range after the worksheet has been saved. It seems that the "usedrange" property only holds the actual usedrange at the last time the workbook was saved.

Is this correct?

If so, is there another way to "refresh" the usedrange property without saving the workbook.

If not, is there another way I can determine what the usedrange actually is at any point in time?

View 9 Replies View Related

Column Disappear When Using Advanced Filtering Through VBA

Jul 9, 2014

Why after the first loop (Z=2) all of a sudden column A in WS ATT disappears. Worth adding that column M in WS L is a "dynamic" range (at first it contains 7 cells) in the sense that it shrinks with each loop (M2:M8, second loop: M2:M7 etc.).

[Code] .....

View 8 Replies View Related

Formulas Won't Disappear When Leave The Cell

Dec 5, 2011

I have a worksheet (in a workbook with many worksheets) where some of the cells display the formula I put in after I leave the cell. I've made sure that the cell format is General before I type anything in the cell. I've inserted new rows, above where the problem is and have tried going to another cell in a different part of the work sheet but I have the same problem. I use the same formulas in two other worksheets. The formulas include other worksheets in them. example =IF(PlotMaster!B2="","",PlotMaster!B2). I can't figure out what is going on.

View 1 Replies View Related

Msgbox Won't Disappear When Opening Inputbox

Sep 17, 2012

I've created some code so that when users want to update something on and Excel template I'm creating for them that the information they've put in is backed up. They give the backup a name using an inputbox and it loops through previously loaded backups that I've stored in a separate sheet and checks if the backup already exists. If it does a msgbox appears to ask them if they want to replace the existing copy. If they choose not to, it re-opens the inputbox.

The issue I'm having is that the msgbox doesn't close before the input box opens and it looks messy and may be confusing. Is there any way, without creating a useform, that I can force the msgbox to close once the user has made a choice before the inputbox opens?

Here is the code:

BackName = InputBox("Give the backup a name", "Backup Name")
If BackName = "" Then GoTo 2

For i = 1 To LR1
If UCase(Sheet18.Cells(i, 1).Value) = UCase(BackName) Then
If MsgBox("Backup already exists. Replace?", vbYesNo) = vbYes Then

[Code] ......

View 1 Replies View Related

Userform Print Preview Pop-Up Won't Disappear?

Jun 19, 2013

I created a macro that prints a label from a userform. The macro used to reside on an XP platform and performed without issues. IT decided they wanted to upgrade the machine to a Windows 7 platform. Now when the userform prints a small window pops up that looks like a print preview of the label, however it is transparent and has a window caption of 'Precut Label' as identified in the userform design. I am including a screenshot of the pop-up. The unusual thing about this is the window cannot be closed, moved or selected in any way shape or form. The only way to get it to close is to view the userform object in the vba editor. The line of code that triggers the print sequence as well as cause the pop-up is: frmLabel.PrintForm. This line of code is housed in the sheet1 object.

View 1 Replies View Related

Make A Command Button Disappear

Dec 15, 2006

I have two option buttons. I would like to have a command button disappear if one option is filled and reappear when the other option is filled. What is the best way to do this?

View 9 Replies View Related

Getting Zero Formula Field When Data Field Blank / Empty

Feb 13, 2013

I have a simple formula ='info page'!b2&'info page'!b5 in places that on my sheet adds a company prefix to a item number, prefix in b2 and item in b5, we have a client that we cant use prefixes but now when I leave the field blank its giving a zero and thats not good either. I'm pretty sure an IFERROR or something will work but can get the syntax right.

View 5 Replies View Related

Refreshing / Triggering A Cell?

Jun 13, 2014


I take this paste text only to get:


this wont work normally until i open the cell and press enter.

Any way I could do that for more than 1 cell at a time?

View 6 Replies View Related

Refreshing Protected Worksheet

Jan 5, 2013

I have this workbook to keep track of current and new work for the team - each individual inputs information on their own tab.

In turn, the current information is displayed on a summary page so we can all see who's doing what.

I want to protect that summary page and its formulas from accidental amendment.

However, while the summary page (when unprotected) updates as soon as someone enters new information on their own tab, the summary page won't update when I have it protected.

Is there any way of doing this - preferably without VBA as it's a work situation and the employer doesn't like VBA code running?

View 5 Replies View Related

Refreshing Activex Textbox

Apr 6, 2009

I've built a spreadsheet with quasi-animation for a physics class on projectile motion. In it there's a animated chart showing velocity change as a function of distance. The chart has on it an ActiveX textbox that refers to a cell that contains a formula showing "V_y = {velocity}". I've tried a number of things to get the display of the textbox to change during the animation. If I break the code at the line that updates the cell referenced by the textbox the display changes. But I can't figure out how to get the display to update while the code is running.

View 4 Replies View Related

Slicer Buttons Not Refreshing?

Dec 3, 2013

Im using slicers of a pivot table which has been generated from a sheet containing around 50 rows of data - not a lot of information. I deleted the information, then started re added information. I then refreshed the pivot table which worked but the slicer still contains information that I input a week ago. I deleted the slicer an cretaed a new one but again, it still contains data from a week ago even thought the pivot doesn't. How to make the slicer refresh to show contains of the pivot?

View 1 Replies View Related

Sum Product Not Refreshing On Opening

Feb 24, 2009

One of my SUMPRODUCT formulae doesn't seem to be refreshing when i re-open the excel file.


If i open the excel all the cells with this similar formula show as 0. If i press Shift+Ctrl+Alt+F9 then they calculate.

I have another SUMPRODUCT formula on another worksheet in the same book that seems to be fine.

I can only assume that the reason why it's not calculating automatically is to do with the TEXT "mmmm" reference, is that correct?

Is there anyway i can have it autocalculate so that if i send this as a report i don't have to ask the ppl looking at it to please press Shift+Ctrl+Alt+F9 when they open it :P

View 9 Replies View Related

Pivot Tables: VBA Refreshing

Oct 16, 2003

Is there a code I can use to update pivot tables e.g every 10 mins?

View 9 Replies View Related

Copyrights 2005-15, All rights reserved