full

Hi everyone, I have a document that works great and has a macro that makes it full screen. (See Below) however I found on opening other Excel documents the Full screen comands below stayed, so I've been switching full screen off when the Document closes (see below) My problem is this. If I...

want to define variables for the full destination of my current workbook, current sheet and current cell. The variable should be called: cworkbook csheet ccell

='\\hinas1\mfg\QRQC\Auxilary\[QRQC A7 fy19.xlsm]OEE'!$G$11 Can the fy19 in the formula be replace with a cell location and full in whatever year i place into the cell?

Hello. I have a column of cells that contain a first and last name. Is there a way I can trim that cell from the full name to an abbreviated name as follows: cell B2 shows "Ann Smith" - this is provided for me. I want cell C2 to show "ASmith" Do I need to break Ann Smith into 2 columns, then...

Hello folks, I have a worksheet that needs to be shared with other members of staff. The spreadsheet has been set up to have edit ranges that allow myself to edit the full spreadsheet and all other users to edit only portions of the sheet. The sheet is protected and shared to the other users...

hi i'm trying to calulate otif (on time in full) for deliveries we make. B has the order number - i can calulate the number if unique orders (three) I cannot work out how to calulate how many order were in full (c=3 and I = blank) (c = 1 ordered, c=3 delivered, I = action: Backorder, Deleted...

Hi Team, How do I Concatenate 3 columns, filling only in NULL/BLANK Cells of other column? In a report we work, it has 'First Name', 'Middle Name', 'Last Name' and 'FULL NAME' columns 1. 'FULL NAME' already has information, however for few people there is no data, which will be NULL/BLANK. 2...

Hello, I have two sheets of data with the almost the same list of items. Just that one contains the few more list than the other, however the full list lacks some data fields I need to get added. I could sort if they were all full lists. Is there a way to get both lists compared and see if...

I'm not sure this is possible. Maybe VBA? Ex 1: I want to select A3 (Turn Down Ratio), B3 (Number of sets), and C3 (Full Scale). Then in column E it will divide the Full Scale into 5 sets by the Turn Down Ratio in A3. Then shown in Ex 2, if I change the Value in A3 and B3, it will then...

When I use the following code everything works: Dim wb As String wb = "xlwings_temp2.xlsx" Workbooks(wb).Activate Application.ScreenUpdating = True Workbooks(wb).Save But I'm going to be moving files around and accessing this subroutine from other folders so I need to use the full path but I...

Hi, I'm looking for a macro that highlight specific words in cell (for example: update, cable, Premium) / words written all capital letters/ full sentences after the symbol ":" Any ideas? Thank You

good morning my boss has given me the task of fining the price before the discount was applied... so A1 has the discount price, b1 has the discount applied & c1 the full cost . does any one have the formula for cell c1? thank you for your help KR Trevor3007

From a report, the data within one column will have multiple line breaks within the cell which I parsed out via marcro. Here is an example the layout of the mentioned cell: <tbody> Full Text: Here is the full sentence Description: Here is the full description for support. Type (1): Color...

Hi, I have the code below which works when I put the full filepath ("C:\Users\Steve\Desktop.. etc..") after the word 'Open' in the last line but I want to have the code refer to cell H42 for the full path instead - my attempt below doesn't work, can anyone put me right, am sure it's a basic...

I can view an Excel workbook in full screen mode but when i exit full screen the workbook travels to a different desktop that is out of reach of my desktop. Because this problem is so strange I made a video to show what I mean...

I have data like column1 sheet 1 11456 11248 11369 11456e 11248e 11369c 11489 Column 1 sheet 2 11456 11369 11248 I used vlookup to get value of column 1 sheet 2 but it gives only for those which doesn't have e and c at last.. How can i use one formula and...

I manage a small business and have been asked to summarize a calendar we have in Excel. Basically we clean buildings every quarter - 1x a year is a full cleaning, 2x are just outside, and 1x sweep/vacuum but not full cleaning --> full and sweep can't be right after each other. We schedule out...

<tbody> Hi, I am trying to come up with a solution to an excel problem I have. I am looking to devise a formula that counts the number of attendances depending on the name. The main table below is an extract from a larger table with a full list of peoples attendance records. Is there anyway of...

Hi, I am new to VBA and would like to use a full path for the Application.WorksheetFunction.VLookup method but cannot make it to work. I really googled for answers but cannot find a perfect example so I really need some help. So in summary I just need help with the arg2 part since I was able to...

Hello I wonder could someone help, I seem to be missing a trick. I have a variable which hold the following information. Lets call it variable1 ActiveSheet.QueryTables.Add(Connection:="TEXT;C:\Users\keames1\Desktop\Configuration Item.csv", Destination:=Range("$A$1")) If I then say With...