Microsoft Excel Forum

Please help me to correct this formula Column K: List of school names (XX-1, XX-2, XX-3, XX-4, XX-5) Column L: List of school Levels (primary, secondary) Column M: List of staff designations working in school XX Find out the TOTAL number of “Principal” and “Vice Principal” working in ONE particular School =countifs((K4:K30, “School...

Hi all, I know that a #Ref! error occurs when the cell that is being referenced in a formula is no longer valid (e.g. deleted) I am trying to make a spreadsheet for my colleague where every month she copies in data from a monthly generated report and the spreadsheet takes the data and pulls out specific information. However, every month she...

I cannot open a excel file as it is giving an error message: "Microsoft office has identified a potential security concern" When i say enable or Disable the file opens and its blank with no data displayed.

I'm working with some data that I have imported from another system, and it has a very strange date format. It seems like everything after 1/1/2000 has the year formated with a letter. For example, 11/04/A0 or 08/04/B6. I have never seen this format before and I'm not sure how to translate this into a date that I can compare. Has anyone else...

Hi, I am seeking a help from all excel VBA expert. I have attached the excel file for reference. In the "Input" sheet there is production schedule that will be generated on submit button click. And the same schedule will also have to COPIED in "Output" sheet. But I am not able to paste it in desired location (blue highlighted area). ...

Hey everyone, I’m hoping someone can help. I’m trying to set up a data import from a table in one workbook to one laid out exactly the same in another. However when I try to set up the link for the first time it’s inserting new cells rather than populating the existing table. I know once the data is in I can choose to format data import and choose...

I have written an Excel Macro that opens a website, adds data to textboxes, and "clicks" to next page. This new page has a "link" that opens a new Form when clicked, I tried to Code the "click" to open the new Form automatically, but get a message that "If you leave this page, you will lose your session and be logged out". Right-clicking...

Sub datesexcelvba() Dim mydate1 As Date Dim mydate2 As Long Dim datetoday1 As Date Dim datetoday2 As Long Dim x As Long lastrow = Sheets("inspection & test plans").Cells(Rows.Count, 1).End(xlUp).Row

Hello everybody I have data in Column A .. Inside most of the cells not all I have slash May be one slash or two or three or four I need to remove any space before and after the slash .. Note that the number of spaces are variable .. Example : Hello / Everybody This is /Just example/ to illustrate / my task .

Hello everybody I have four cells which I need to navigate through using Enter key My range is ("D10:D13") If I was in D10 and press Enter then go to D11 (That's the deafult)>>>> If I was in D13 and Press Enter key I need to go to D10 again As for other cells no change in using Enter key Hope it is clear

Hello everybody Is it possible to disable the keys Ctrl + Alt + Delete in excel? I searched a lot but found no results which can do that

OK first off hello! I am new to these forums and - though I dabbled a bit in Basic when I was younger - new to programming in general. I have searched using Google rather extensively but cannot figure out how to do what I'm attempting...perhaps because I am having a hard time applying programming principles because I am new to macros and VBA. ...

I have a user who was working on an Excel 2007 file from a thumbdrive.. all of a suddem the file will not open and generates the following error: "Excel cannot open the file 'filename.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the...

Hello Friends I have some problems in Excel and need anybody's help. I have a file with many columns but especially I need Drawing Number and thair Approval status. Match Drawings Number and get its last status. Suppose Drawing Number Rev Status QV-00-VEN-C02-14400917-0001 0 Under Review QV-00-VEN-C02-14400917-0001 ...

Hi, Sorry if I'm asking a super easy question. From sheet Details I need to copy next rows each time I click like for example - A5,B5,C5 to the next empty row in destination sheet. From Invoice I want to copy fixed rows in next avilable rows in the destination sheet. Below is the code that I have however it copies the fixed rows from Details...

Sub WorkBook_Open() RemoveEmptyRow ConcatenateColumn DeleteBlankColumns SaveFile End Sub Sub SaveFile() 'ActiveWorkbook.Save ThisWorkbook.Saved = True

I want to create a microsoft query which would pull data from an access database. I need my users to be able to filter the data however they wish, which I know is possible using a query. However, I don't want them to be able to make edits from a query. Is there a way I can disable a query from making edits to my table?

Hellow, I am trying to make Railway time table in excel through Visual basic. I have 2 combo Boxes (From and To)& Multiple Text Boxes to populate Train No, Train Name, Arrival & departure (TextBox 1-2-3-4) respectively. When I select Combo box 1 & 2, data is populated in all cited 4 text box correctly(1-2-3-4). But in text box no....

I have a template that will be used to track data across multiple outside spreadsheets. The outside spreadsheets will be imported to different tabs of the template. I know that once the data is imported, the connection properties can be adjusted so that the data refreshes when the template file is opened, however, this is tedious as new data...

I am tring to combine two macros with "ElseIf". both work on their own, however, i keeping getting an error with "ElseIf". My code is Private Sub Worksheet_Change(ByVal Target As Range) Application.ScreenUpdating = False If Target.Address = "$B$1" Then Dim ws As Worksheet Dim cWs As Worksheet ...

Hello, It would be really great if I could find a way to consolidate across several tabs tables with identical structure but different content into one table or one pivot, without resorting to stitching multiple tables, being them very long, and variable in the number of records. I have a table structure like: table 1 to table n: Item (text) |...

I am working in Excel 2010 and am trying to print a report from another tab only if a specific cell is within a specific range. When I click the 'Print' button I get "Run-time error '424': Object required" when it gets to my LOW and HIGH strings. I do not know how to fix this. Any clues would be appreciated. Sub PRINT_SLURRY_Click() ...

I am looking for help writing a MACRO that picks a number from excel and go to web page copy text and paste it into excel 1> We have 4 Application Number in excel sheet 10/689,948 10/458,262 10/618,627 10/845,304 pick 1 by 1 & go to web site (http://portal.uspto.gov/pair/PublicPair) 2> Enter this number & search

I'm using option button form controls in Excel and I can't seem to figure out how to change the font size. When I right click, there is a 'format control' option, however, there is no font options within this option. Can someone please help??

Currently I have a list of items in coulnm A in column H I have the quantity used and in coulmn E I have comma seperated values (could be 1 could be 30). I have created a Text-To-Columns action to move the info from column E to individual columns for example, if E2 had 3 comma seperated values the code takes these values splits them and moves them...