Hi, I recorded my step-by-step entries and changed some of the commands as follows: Sub Macro1() 'Range("Q95:Q99").Select = This code was replaced...

The following is a process for which I'm hoping to create a macro. The macro will be for a file in which all cells (including numbers) are formatted as text,...

I have set up a template with hundreds of links to other worksheets in the same workbook. I want to cut the links, so that only the data (values) shows, after...

hi guys, i've created an excel worksheet that holds names in work groups. when i cut a name out of one workgroup to paste into another it removes the border as...

I need a Cut and Paste macro which will cut every second row (A2,A4, etc) and Paste them to a destination (E1,E3, etc) one by one. So A2 will be cut and...

I just got a new Dell with Office 2007. Computer is a Vostro 430 with 4GB of RAM and a 2.8GHz processor. Cut, copy and paste operate extremely slow in...

When i use the cut, copy or paste function from the dropdown menu workstation locks up and I have to reboot. W/S also locks up when i simply do:A1+B1+C1 etc....

Good afternoon, this is not a homework question, I am trying to brush up on statistics for my job. I am having a problem with a question. A 4 year college will...

Does anyone know of a function (regular or ASAP Util) thay will allow a certain range of cells from one column to be cut and pasted across several columns...

i need to cut the first 14 characters from a text string - for instance I need to return "E-100-250-4332" from "E-100-250-4332 Rental Expense". I can't use...

Hi I'm trying to look down 4 columns for "value 1" to "value 10" (column I,K,M,O). upon finding, for example, "value 1", it then lists the numerical value...

Is there a way to cut part of the text in one cell and put it into another? For example, if I have a dropdown list in cell B3 that includes both an account...

Hi I am trying to find the actual cycle time of issues as they pass through different stages. I have attached a sample spreadsheet. In the example below...

I am trying to calculate the time between 2 dates, if the latter date occurred in 2007. Here is where I was going, but it doesn't seem to...

I am trying to calucate cycle times. I have 2 milestones (each with a planned and actual date Column A: Milestone 1 Planned Column B: Milestone 1...

Good day, No, I'm not James Bond nor am I a criminal trying to hack into the CIA... Just wanted a hand with a simple cypher if anyone can help. I want to be...

d

I've made a spreadsheet to report on a sheet of raw data. Is there a maximum number of column heading that can be used when defining the criteria? I've got up...

Hi, I was doing my excel and not sure what have i clicked. the worksheet bar suddenly disappeared. My workbook has a lot of individual worksheets and now i...

Hi everyone, I was wondering if anyone can tell be a better way to do this. I am working with financial information in Excel. I have roughly 50 locations and...