position

Hello Excel Gurus, I am running the following code to do a simple task which is to bring all the sheets in the Workbooksheet to Position A1 and if there are scroll in the other sheet bring them to original scroll position with Columns like A... B...C ....D....E... etc etc. I am getting the...

Hi, I have some table data where I would like to generate an aggregate reciprocal position. This relates to modelling allocation of costs within an organisation. E.g. 5 departments a, b, c, d, e receive costs of -1, -2, -3, -4, -5 respectively. I would like to generate in the cleanest and...

<tbody> A B C D E F G H I J K 1 4 100 200 300 300 2 3 50 100 100 3 5 25 50 15 225 541 </tbody> Okay, I feel like I am almost there, I just can't get thisformula right. I have a number of rows with data. Some rows use morecolumns than...

I will illustrate my challenge by way of a simple example. Suppose I have a list of 25 baseball player names (A1 through A25) on sheet 2. Suppose, further, that I create a "yes-no" drop down in each cell in the range B1:B25 (sheet 2) - this lets me choose which players go in today`s lineup. On...

Hi folks, I'm trying to create a macro that will allow the user to input newrows in a protected worksheet based on a starting point and a number ofrows. The newly entered rows will be copies of the row above where the new rows willbe entered. That row contains formulas which must copy with the...

Using Excel 2000 Hi, Data In columns C:P, R:AE are the result columns. I want VBA or Formula which can extract only 3 first sign "1", "X" Or "2" find in the each row For example... there are 14 positions of 3 signs "1X2" in columns C:P Search for 1st sign in the row 6 there is "1" in the...

Hello I'm trying to open 4 windows of "explorer.exe" (windows explorer) application and I would like to define their position and size. I found some code which works perfectly with notepad ! I've tried to modify it ...to make it work with "explorer.exe" I've replaced : np_retval =...

I'm sorry in advanced if my explanation isn't very clear, but here goes! I've got a grid of results from four teams who are scored on a weekly basis. So far, my calculation has the following which highlights how many times each team has won (listed at the top of each team)...

In column A1:A14 the term "Red" is displayed in in only one cell and in column B1:B14 the word "Target" is displayed in only one cell. I want to return a value in in Cell C1 that says "Above" if "Red" is above any row position than "Target", and display "Below" in cell C1 if "Red" is on an...

iam giving input in A1 TO A10 In sheet 1 at sheet 2 shapes should appear with specific position as mentioned in sheet 1(A1:A10) Can i get help with this? Sub populatearrow() Dim shapi As Shape Set shapi = Sheets("Sheet 2").Shapes("Rectangle 2") Dim shap As Shape Dim x Dim position position...

Sheet 2 A1=10 A2=20 A3=30 A4=40 A5=50---etc(Values are not constant) By using this code the shape is appeared after every 5 columns ... if there is a box(shape) position appeared at 5th column then match with that box(shape) and add one more box(Shape) above this "Arrow2" box as well as insert...

Hello, Hope anyone could help me with the below problem. I'm trying to distribute an amount based on a set % for each position but also needs to consider their working days number. Amount to distribute : 100.000.000 <tbody> Employe Position Position % Working days Distributed Amount A...

https://imgur.com/wEYK5Fs I am working on IF Function to get the value so I can use the value to set the conditional formatting. This uses two cells in order to get the values that I need. V= Vacant, F = Filled , FG = Filled gain Column A, B shows the current employee who is filling the...

Does anyone have any code that inserts a single page pdf page in page 4 position in another pdf document?

Hi, I need to find the position of 2 values, lets call them "X" and "Z", on an array. I've got a board that repeats X and Z multiple times, and what i wanted is the column position of the first time X presents itself on the Row im looking, then the first time Z presents itself on the same row...

I've got two columns, department and position. I want to smush them together into one in order to use vlookup from another sheet. The position number needs to be 3 digits long in the final product. I have 1,2, and 3 digit position numbers. I can of course make it show the leading zeros...

I can never wrap my head around why these don't work for me. :mad: If Position = Defender or Goalkeeper AND G = 0, then show 1 if not show 0 =IF(AND(OR([@Position]="*Defender*",[@Position]="Goalkeeper"),[@G]=0),1,0) Also...

Good Morning, I trying to use index and match to lookup and employee name based on the day of the week and their position. for example, I want to return the employee name who is in position "1" on Thursday. <tbody> Employee Sunday Monday Tuesday Wednesday Thursday Friday Saturday A OFF 2 3...

Hi everyone, I am looking for some help. I have to manage points and pay for a racing series and I'm trying to create a workbook to help me keep track of everything. So this is how I'm going about it so far. If you think I'm on the wrong track, please make any suggestions I am just a novice...

Good afternoon board! I am constructing a portfolio and I want to auto generate my positions. My goal is to determine my portfolio position at every trade date. Context: I have two tables in a "Transaction History" worksheet, one with all the Trades and the other with all Dividends Received...