User Profile
Sue_G
Brass Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Cross Referencing Data in Excel
Hello, I have a spreadsheet that lists document numbers that are stored in a document management system. I have to cross reference the documents in that management system, which means I have to go into each individual document in the management system and add in all the documents where that individual document is referenced. The attached spreadsheet lists all the documents in our system (column B) and each document where they are referenced (columns C-AP). Is there a way to have Excel search columns C-AP, find a specific value, and provide me with a list from column B where that value is found in columns C-AP?376Views0likes1CommentRemoving the tip line when adjusting columns
I usually adjust columns in Excel by grabbing the gridline and dragging it to the ruler mark where I want it. However, the box that shows the column width is in my way when I try to align the column width to the ruler mark. Is there a way to shut that off? I have attached a screenshot of what I'm asking about.876Views0likes2CommentsMultiple IF / OR Statements?
Hello! I have a sheet where I'd like to fill in data, based on the data range from 2 other series of cells. I have attached a copy of the file for your review. In cell C9, I'd like to fill in the data from column H, where Column G has a number >0. The values in column G will have numbers greater than 0 only one at a time (so if there is a number >0 in Cell G4, cells G4-G9 will always be 0, if there is a number >0 in cell G7, cells G4-G6 and cells G8-G9 will be 0, etc.).Solved964Views0likes2CommentsText Boxes Moving/Resizing on their own
Hello, I have an Excel file that includes a text box and shapes. When I created the document, everything looked good; however, after saving and reopening, the text box and shapes have moved on the page. I have attached the Excel file along with a Word doc that has screen shots of the difference. Note: When reopen the file, the text box has moved, but the text is still within the box, and if you were to click on the text, the text moves out of the box. I have tried all different property settings: Don't move or size with cells, locked, unlocked, lock text, resize to fit text, etc. I can seem to figure out why it's doing this. If I resize the sheet, and then resize back to 100%, everything moves/resized back to where it was originally. I just discovered that the file will print correctly, so it's not a huge problem, but it would be nice if they didn't move/resize on their own.8.1KViews0likes5CommentsGOTO a specific cell, based on another cell's data
I have a spreadsheet where I would like to move to a specific column, based on the data entered. For example: In A1, I enter a name: Joe If Joe is entered, I want to go directly to column J in the same row, (without having to either tab through the columns, or use my mouse to get me to column J). and enter more data. If I enter a different name in A1: Mary If Mary is entered, I want to go directly to column H in the same row and enter more data. I want to be able to do this in every row, e.g., I enter Joe in A2, then go directly to column J2, etc. The data entered in column A is a specific list of names.25KViews1like11CommentsSheet/Column Protection
I have a workbook where I want to protect four columns without having to protect the sheet. I have a VBA command that allows me to protect cells, but as I am very new to VBA, I'm not quite sure of what I'm looking at yet, and I've not been able to modify the code to have it do what I'd like. Is there something available where I can protect the columns but still be able to sort and/or filter, delete rows, etc?545Views0likes0CommentsUpdating cell values from one cell based on another cell's data
Hello. I would like Excel enter data from one cell into another cell, based on another cell's entry. For example, I have a date in column A, in column B, there will either be a date entered, or n/a. If column B is n/a, then I would like Excel to take the date in column A and enter it into column C. If column B is a date, then I want to enter data into Column C myself. Is this possible?Solved150KViews0likes4CommentsExcel converting .xlsx files to .tmp files.
I am using MS Office 365 ProPlus. Recently, I have had two files convert from .xlsx to .tmp. Both files are housed on a network shared drive. Under normal circumstances, only two people share these files. Recently, a third person has been editing them. This never happened when the original two people shared the files. I understand Excel creates the .tmp file when opening a file, and is supposed to delete when saving/closing the file. Can someone tell me why this would start happening? One of the files is setup with permissions for read only for fellow employees and change for the three who are currently editing it. The other file has no permissions setup. It's open to anyone. I can easily retrieve the files with no problem, but I'm wondering why this would happen and how do I keep it from happening? Any suggestions?2.2KViews0likes0CommentsExcel Question - Skipping Columns
I hope someone can help with my question. On my spreadsheet, I would like to skip over certain columns when entering data. I was able to set it up when I don't want to enter data at all using the following code (which, quite frankly, I have no clue what it all means, but I managed to make it work): Private Sub Worksheet_SelectionChange(ByVal Target As Range) Static sRg As Range Dim ColumnOffset As Integer If Target.Count > 1 Then Exit Sub If Not Intersect(Target, Union([B:B], [D:D], [F:F])) Is Nothing Then With Target Application.EnableEvents = False If Not sRg Is Nothing Then If sRg.Column < .Column Then ColumnOffset = 1 ElseIf .Column <> 1 Then ColumnOffset = -1 End If Else ColumnOffset = 1 End If .Offset(, ColumnOffset).Select Application.EnableEvents = True End With End If Set sRg = ActiveCell End Sub There is probably a simpler way to accomplish this,..if so, please feel free to make suggestions. What I don't know how to do is skip over columns where I don't want to enter data based on another column's entry I make. For example: I enter N/A in column A. Columns B and C are set up to automatically add N/A if there is an N/A entered in column A using an IF formula. Is there a way to have excel skip over columns B and C and go directly to D when N/A is entered in column A? But if something other than N/A is entered in column A, I want to be able to enter data in columns B and C.1.1KViews0likes1Comment
Groups
Recent Blog Articles
No content to show