special

hi need help for a look that do Run a loop cycle that searches for the word "Special" in column A1 (the cell a1 contains different words inside) If true looking if b2 = "Quantity" deletes b1 row) in red is what i need to be deleted Thanks for help A...

Hi, I have a programmable keyboard and currently have a copy and paste button assigned. I am trying to make my paste button default to paste special. Is there a setting or something like that to set in Excel?

Hello, I have spreadsheet that has 18 columns containing numbers ranging from 0 to 99,999.99, and I need to round each of these numbers. What I need to do is as follows: If #<100 - Then round to nearest Tens place (i.e. 64 would become 60) If #>100 - Then round to the nearest Hundreds pace...

Hello all, and thanks for reading. I need to import a new spreadsheet (or simply its data) into an ongoing Excel project that I've been working on. The only identifying data on this new document are social security numbers (SSNs). They are hard-coded with hyphens, which I text-to-columns'ed...

Greetings. I need your help with one match function that is failing only for some situations. The functions is right now as following: =INDEX(Tracker!Q4:CR4,1,(MATCH(Status!K3,Tracker!Q4:CR4,0)-1)) Its purpose is to read the a character string from "Status!K?" cells, search for that string...

Need help with vb script to do the following Copy & Paste special (values) from Sheet “A3”.Range(B6:E8) AND Copy & Paste special (values) from Sheet “Timeline”.Cell(F6) TO Sheet “Change Log” WHEN Sheet “A3”.Cell(M3=”YES”)

Hey everyone, I am completely new to VBA and would like to seek some help on Macro codes to perform copypaste special between workbooks. Source fie is a template with different file names and locations everytime I need to copy something from it. It is a source file that I need to copy...

I'm running XL version 2010. I have a question about formatting for a special text character. If I have values such as 3.6.9 and 3.6.10 that correspond to product versions, is there a way to format the special text editor to have the numbers after the second decimal treat them as 9<10, while...

Hello I am using paste special to collect data from some data logging software using DDE. The data appears in excel and updates live no problem (the paste special is set on my worksheet) I then have a macro to manipulate the data but it doesnt 'notice' the live data changing it only works...

Hi, I'm not sure how to word this so hopefully what I'm saying makes sense... I would like to copy a cell on excel & I normally do this by pressing Ctrl & C... The issue I'm having is when I am pasting it into a different software that my company uses it pastes it with 5 square boxes at the...

Hi everyone, I have a column that has data like this: Jul Aug-Sep Oct Nov-Jan I want to sort it by months. When I use the custom list in normal Sort, it only works partially -- I end up with this: Jul Oct Aug-Sep Nov-Jan I tried creating a custom list such that anything that started with...

This is a macro i have been using to update update information from one sheet to the next empty row in another sheet within the same workbook. Sheet2.Unprotect Password:="Climber7c+" With Sheets("FeedbackForm").Range("B7:N8") .Copy Destination:=Sheets("Feedback & Performance").Range("A" &...

I have a VBA module in which I need to add formatting to a number based on several criteria. (Excel 2003). If a record in the worksheet meets these criteria, the cell should be displayed as a right-facing triangle (U+25BA), the number and a left-facing triangle (U+25C4). I am able to do this...

Heya, I've got the following spreadsheet: As you can see, I've sorted it by column A. However, sometimes the date is the same and then it doesn't always go right... see f.ex. 17 dec, where the ship arrives in the harbour and then is at sea again and then departs :nya: Not exactly what...

OK im half way there. I have in my Word document my excel spread sheet, and on the 2nd page i have a 'paste special', 'paste link', 'picture' spreadsheet (copy of the first) The whole reason is because i want the second to update itself if i do anything to the first one BUT... as soon as i...