excell 2010

App 2500 rows of data. Yellow A2,B2,C2,D2 must be moved to grey E1,F1,G1,H1. Do I type the instructution/formula behind fx Thank you very much and regards ...peter

Hello, good people from MrExcell. :) I have some 210 computers in local network. And i have excel that creates and sends files to different folders on them. Without going in needless specifics - my question is if there is a easy way(or any way?) to check and Flag computers that are not turned...

I want to input the value of B2 in cell F2,F3,F4 , value of B3 in F5,F6,F7 and so on like the followings. I tried to put the value B2 by referencing in F2,F3,F4 manually then copy all 3 cell(F2,F3,F4) and paste special (all using source theme ) immediate next 3 cell but it didn’t work rather...

Hello, still relatively new to vba and working on creating a macro that updates expense rates based on a certain qualifier entered. I wonder if any wizards here could take a gander and let me know what wording I need to change for this to work properly as I'm yet able to find anything readily...

Hi All, I need to create a Gantt chart that shows how long it is taking to approve construction drawings. I have attached a schedule of the drawings in question with each one having its own reference number and a issue and review date for each revision. I need the Gantt chart to show the time...

I would like a FORMULA that change letters according to table of values that i make. example: êíöä = LOVE (because i made a table that show: ê=L, í=O, ö=V, ä=E). example- Picture: As you can see in the picture above, AB1 - the word I want to decode. AB2 - the end result that I want to get...

Hello I'm having a small problem which I just can't solve as I'm a very beginner in Excel VBA. I've been searching for different examples since last week but it doesn't really works. It's quite important for me so I'd really appreciate if someone could help me. I'd like to make a chart from a...

hi, new to this site. dont have a lot of experience with VBA. i need a vba code to do the following Values in column A and C, Digits in column B and D the Macro needs to compare the data of column A and B against column C and D and cut / move the duplicate data to Sheet2. it needs to be in...

starting from scratch, I need to come up with a custom function to get cells with key words in a column and add up hours to get me the total hours for each day(column). here is how the sheet is set up. column a,b&c are frozen and contain equipment id and general info about the...

Hello Everybody, I need your help in correcting this code. I need a range from specific row to specific column. The row and column has to be dynamic as it changes everyday. I have been through few posts on this but nothing what fullfilled my requirement. Code: 'Last Column Dim col As...

<THEAD> A B C D </THEAD><TBODY> 1 Name Category Positive / Negative Number 2 AA x Positive 103503253.7 3 BB x Negative 42125221.42 4 CC y Positive 85401512.22 5 DD z Positive 30600783.38 6 EE y Negative 32698328.06 7 FF y Positive 36048545.1 8 GG y Positive 993354.51 9 HH x...

I'm not an excel power user by any means, so i'm having trouble getting a column in one worksheet to compare against the same column in another worksheet. I have two different worksheets in the same workbook each sheet contains a different data with the exception of one column. The columns...