Column A Disappeared - How To Get It Back
Jul 24, 2012Column A disappeared and didn't come back. I even arrow over to the left margin, but the furthest it goes is to column B. How can I get my column A back?
View 5 Replies
ADVERTISEMENT
Calculating Distances Between Back-to-back Locations
Aug 11, 2012I have a layout something like the following:
A1
A2
A3
[Code]....
Where each (i.e., A1) represents a location. I have tried to use a coordinate system but this will not work for the back-to-back locations. (Assuming each location is 2 feet wide, For example A1 to C1 is 4 feet apart, not 2 feet (as Euclidean or rectilinear would calculate it as).
Would there be a way to incorporate an if statement for those locations that are back-to-back? As a rectilinear distance calculation would work as long as the locations are not part of the same "block".
Ultimately I am looking to have a matrix which contains all the distances between each location:
A1
A2
A3
B1
[Code].....
Mapping The Data From Back Of The Column
Jan 22, 2009I am using the Formula of Index here as i have a sheet names with Details and mapping i have a company name for which i have to map the policy no from the details sheet. The Thing is i will not use Vlookup i need a formula of Index which maps the data from the backwards range. Attached a excel sheet.
View 4 Replies View RelatedLooking Back Through Cells In A Column To Find Specific Text(s)
Feb 14, 2010In the attached sheet I need to check on the Destination in column B, and if it matches set criteria, divide the figure in Column E by 2. eg If LAX is the destination, then for any rows directly under LAX until the next destination appears, column E needs to equal column D divided by 2. If the Destination is not LAX, then Column E equals Column D.
the difficulty I am having is that there can be a variety of row numbers for each destination. I am having trouble creating a formula that can basically work backwards from Row-1 in column B until it gets to a text string, and check that text string against the criteria. so it may be row -1 up to about row -9 dependant on the number of flight times available to each destination throughout the week.
How To Move Data From Back Column To Front In Excel
Mar 20, 2014How to move the data from the back column to the front as below
A
B
C
2
3
1
3
1
2
to
A
B
C
2
3
1
3
1
2
Search Criteria Bring Values Back To A Results Column
Apr 25, 2008i have the following macro which finds instances of a search criteria and brings them back to a results column. what i need is instead of having the word GD: appear before each result i need it once at the begining of the results
LastRow = Sheets("design owb").Cells(Rows.Count, 10).End(xlUp).Row
Application.ScreenUpdating = False
For i = 26 To LastRow
Target = Sheets("design owb").Cells(i, 10)
With Sheets("design")
For J = 2 To 54
For K = 4 To 11
If Target = .Cells(J, K) Then
Sheets("design owb").Cells(i, 11) = Sheets("design owb").Cells(i, 11) + "GD: " & .Cells(J, 15) + " | "
End If
Next K
Next J
End With
Next i
Application.ScreenUpdating = True
Gridlines Have Disappeared
Oct 26, 2008I'm not sure what I have clicked on, but I have no gridlines when entering data into my spreadsheet.
View 13 Replies View RelatedDrop Down Box Disappeared
Oct 23, 2007I have created some drop-down boxes on a tracking spreadsheet. Last week they were they today they are gone.
I went in and cleared the cells and re-created by dropdowns. I did remember to click, in-cell dropdown, but when I click on the cell it is not there.
Now if I right click on the cell it does give me an option to choose from a drop down. So my options are still there but why are they not appearing in the cell when I click on it.
I am using Excel 2003 with Windows XP
Tabs Disappeared
Nov 25, 2008I am unable to view my tabs in excel - the tabs are there, they just can't be clicked on per say. I have double-check the tools option and verified the correct box is check to view tabs, however, I can't view the tabs. I tried to color a tab and it colored it red, but I can't really view the tab. I can see a red line underneath the directional arrows when I am working on that particular worksheet, but again, I can't view/click on the tab.
View 9 Replies View RelatedSum At Bottom Disappeared
May 2, 2007you know that part at the bottom toolbar which tells you when you select two or more cells what the sum/average/max/min is? Mine's disappeared.
View 2 Replies View RelatedCell Highlighting Box Has Disappeared?
Jan 3, 2013Was working away on one of my spreadsheets and the black square that surrounds the cell you click on has vanished. i.e. if you click on cell A1, you normally get a black square surrounding the cell A1 to let you know that you are on it. That black square has disappeared.
It seems to affect any spread that I open but if I open a new spreadsheet it is there.
Excel File Has Disappeared?
Mar 17, 2014I have used this file extensively for months. I inadvertently clicked something this morning that made the file "disappear". I can see the file in its folder and open it. But, once opened, I do not see any of the tabs and the name of the file does not appear at the top. I did ALT F11 and can see the tabs in the VBA but I'm missing a step to make the tabs reappear. Since I don't know what I did to make everything disappear,
View 2 Replies View RelatedCustom Menu Disappeared.
Jun 17, 2009Just curious as to what could make a custom menu or custom button disappear from Excel upon opening it. I had created a custom menu with personal.xls macros in it for someone here a while back, and today it was completely missing.. although the Personal.xls folder still existed with the macros.
I am quite sure that they did not manually remove the menu by right-clicking and selecting Customize and dragging back the menu items...
Worksheet Tabs Disappeared?
May 18, 2005I have been presented with a rather odd thing with Excel. We have a wookbook with six worksheets in it. When the first of worksheets is displayed, all the other tabs "disappear". The whole bottom tool/navigation bar is no longer displayed. How can I get it back?
View 8 Replies View RelatedDrop Down Lists Disappeared
Nov 23, 2006I've created a sheet with a number of drop down lists using the validation menu.
Whilst working on the sheet the lists have disappeared! The validation options are still there and refer to the correct cells that have the correct details in them, but when I click in the cell that should have the list in it I don't get the down arrow to click that shows the list.
I've also tried creating a new list in another cell but that does the same.
Hopefully i've just changed a setting that stops it working and I can unchange it - but I don't know what's caused it.
VBA - Solver Reference Disappeared -
Oct 30, 2007When I go to excel ==> ALT + F11 ==> Tools ==> Reference ==> I can't seem to find "solver" anymore. My code was using the solver module, and now my code does not work. I can't find "solver" to check it.
View 2 Replies View RelatedRange Name Toolbar/Box Disappeared
Sep 26, 2006After running a macro, the range name toolbar/display box in Excel has disappeared. how to get it to display again?
View 6 Replies View RelatedSeries Line Disappeared
Oct 10, 2006I have a chart of type 'Line' that shows a KPI item measured quarterely. It has a single series that references the 'data' worksheet. Since it is measured quarterely, the months in between will have a null value. It has been working to date, but since I have added the data for the latest month, the series line has disappeared. Only the markers remain. The series line is formatted in a vivid blue.
I can't attach the spreadsheet because its 152KB. One thing of note is that when I select the series line, not all of the markers get highlighted as expected
VLookup To Find The Customer And The Dates And Then Bring Me Back An Asterisk In A Separate Column
Jul 27, 2007I have 2 spreadsheets. One is a promotion calendar that lists the dates that promotions on a certain product runs. The other is a shipment grid of shipments of that product to the customer.
I want VLookup to find the customer and the dates and then bring me back an asterisk in a separate column to show me that that certain week that product was delivered was a promotion week. The problem I have is using Vlookup to lookup 2 things at once (and if they match to the promotion calendar) and return me an asterisk.
Here is my formula now:
=IF(VLOOKUP(J2&" "&L2,'East Data'!M:AU,2,FALSE),"*",0)
J2 is the customer name
L2 is the week
"East Data" is the spreadsheet with all of the promotions and customers.
Excel 2010 :: Status Bar Disappeared?
Nov 1, 2010From time to time, the status bar in excel 2010 is not showing (I don't mean the information is not showing, I mean the bar is not there at all). In previous versions I would go to view>status bar...
how do I get the status bar back in excel 2010?
My 'FORMS' Toolbar Has Completely Disappeared
May 21, 2007My boss has passed me his laptop that he had been designing a spreadsheet on (Excel 2000). The 'forms' toolbar has completely disappeared. When I right click the area where the toolbars are normally docked it lists every one except forms. clicking customise appears to list a few more menus - but no sign of FORMS. If I click 'new' in customise and type in Forms for the name it tells me 'a toolbar named 'forms' already exists' (so where is it!)
how I can get the toolbar back -
Relative Reference Button Disappeared
Apr 10, 2007When I click Tools Macros Record New Macro I usually get a box which allows me to chose relative reference and is displayed until I click stop.
View 4 Replies View RelatedWorksheet Tabs & Minimize/Maximize Disappeared
Aug 31, 2007Edges of worksheet have gone - no tabs, no minimise/maximise.
View 7 Replies View RelatedExcel 2003 :: VBA - Worksheet Object Temporarily Disappeared
Oct 25, 2011I have a simple macro that cycles through the sheets in a workbook, and if the sheet's codename matches one of a defined list, some of its data is added to a summary sheet.
The macro works exactly as intended, but a strange thing happened yesterday: some data was missing from the summary sheet because one of the sheets was being ignored. This sheet is named 'MCP' on its tab, and has codename Sheet8.
Here's the strange part: on stepping through the code, cycling the sheets, I noticed that the sheet icon, name and codename had disappeared from the Microsoft Excel Objects folder in the Project Explorer. When the loop got to the sheet in question
Code:
For Each ws In ThisWorkbook.Worksheets
Debug.Print ws.Name
Debug.Print ws.Codename
The above code displayed its name (correctly) as 'MCP', but its codename was blank; the sheet was therefore skipped by the code because the codename had to match against a defined list.
While I was pondering this, and doing some web searches, the sheet then re-appeared in the Project Explorer and everything worked again.
My question is this: is it likely to be due to the workbook being shared? I know that workbook sharing in Excel is often discouraged, but this is a simple workbook only used by a maximum of three users (two of these had the workbook open at the time the issue was reported)
I've changed the code so that the sheet name is inspected in the event that the codename is blank, which should guard against the issue provided sheets are not deleted/renamed.
Windows XP, Excel 2003
Copy The Current Price Back To Sheet1. The Current Price Needs To Be Pasted Back Into Sheet1 (next To The Existing Price)
Jul 24, 2006All data is located within one book. I have two sheets with material codes in each sheet which include pricing (existing and current)
Sheet1 (has existing material codes plus existing pricing) Has about 1200 lines
Sheet2 (has current material codes plus current pricing), has about 36000 lines
I need to cross check if the material code (taken from sheet1) are still available in sheet2, and if they are, copy the current price back to sheet1. The current price needs to be pasted back into sheet1 (next to the existing price). If the material code doesn't exist (for whatever reason, in sheet2), the program needs to move onto the next line and leave the current price for that material code blank. The program should finish once all the lines in sheet1 are completed. I have attached a sample of what I'm trying to do,
Can't Scroll Back To Top
Dec 26, 2008I have a spreadsheet with some scripting that automatically emails the report to whoever is on the sheet. I'm not sure what kind of scripting it is. I think my boss found it somewhere.
Whenever I scroll either down or up, the first 3 rows disappear and I'm not able to scroll back up. The scrollbar shows that I'm not at the top, but it won't let me go back up. The first 3 rows contain the button to send the email. If I close out without saving and open it again, its fine, until I scroll up or down.
Back And Forth Between Workbooks
Feb 2, 2007Copying information from various sheets from one workbook to paste into similar sheets in another workbook? It would involve switching back and forth between workbooks.
One Hundred Back To 100
Sep 26, 2008I found a way (on this board) to spell out numbers...I.E.: 140 = "One Hundred Forty" .
But is there a way to convert "One Hundred Forty" to 140 and format as a number or general or pretty much anything but text? I thought would be as easy as Cell Format > Number
Back Draws
Dec 3, 2008Back Draws! ...
View 9 Replies View RelatedIF And Vlookup Functions Which Comes Back Yes Or No.
Sep 20, 2007I have a spreadsheet with over 20,000 rows. From another spreadsheet I need to find if any of a list of 90 customers are within the first, using a simple IF and vlookup formula which comes back yes or no.
I am using: =IF(A2 = VLOOKUP(A2,ihcust!B:B,1),"YES","NO")
However, although this works when they are spelt exact in both sheets if they are not it will say no.
eg. If I was Looking up "Joe's Icecreams" from the list of 90 but in the other sheet it is listed as "Joe's Icecreams (admin)" it would not recognise it and come back no.
Is there away to get around this problem