Search results for query: *

Copying data to a new cell under a specific condition I have column 1 which contains data columns 2,3 and 4 will contain a flag (1) if there is a flag in any of columns 2,3 and 4 i need the data from column 1 on that row copied to column 1 on another sheet to spice things up a bit some rows...

Cheers It sounds like a good start Could you please send it to splendid_monkey (at) hotmail.com

Dummy Printer Does anyone know of or used a Dummy Printer program Basically I need a program that can act like a printer i.e. buffer jobs as a printer would and pass them through at a set rate The reason for this is to test large loads on print servers without printing reams and reams of...

Dummy Printer Program Does anyone know of or used a Dummy Printer program Basically I need a program that can act like a printer i.e. buffer jobs as a printer would and pass them through at a set rate The reason for this is to test large loads on print servers without printing reams and...

Macro used provided by RamziSaab (MIS) cheers m8 Sub seperate() With ThisWorkbook.Worksheets("Sheet1") r = .UsedRange.Rows.Count n = 1 For myrows = 1 To r n = 4 strname = .Cells(myrows, 4) For i = 1 To Len(strname) yy = y y =...

List them a good start would be just to list them better would be to list them with the id in column 1 so if the same value is in two different rows in column 3 it would also list the row by coulum 1 i.e. 0#CNGEQCH.LP is in 2513 and 244

yes all the codes are sperateed by spaces and yes only column 3

How do I find duplicate values Don’t say use find and replace there are over 20,000 possible duplicate codes I have an excel sheet with 3 columns It looks like this Column 1 2513 244 2235 1247 1733 1020 2000 2277 Column 2 381 376 375 372 367 359 358 356 Column 3 0#CNGEQCH.LP...

I need to update fields in an excel workbook I have 6 columns 4 with text in I need to add " to the beginning and end of the data in each cell that has test in I don’t mind doing it column by column but I cant update manually as there are over 4000 rows any ideas

I am using some automated testing tools and need to clear the Start-Run screens dropdown in every other vision of windows you just click Clear on the recent files under start menu programs tab of the Taskbar Properties but under NT it does not clear it any idea’s

Ok here is the problem I need to write a macro that will enter information in an empty column. If row 1 through 100 is has a column with a value of closed in it, it must paste =INT((J**-C**)/7) into the empty column and if the column says Open it must paste =INT((TODAY()-C**)/7) into it The list...

You got it cheers :)

It would be however A Macro would be nice seeing as updates are received over 20 times a day

Basically I have an excel sheet with 10 columns one column is called Closure Status with the Values 0 and 1. 1 needs to be changed to Closed and 0 to Open I also have two other columns that are called Closure Date and Verify Date these columns contain dates however on open rows they contain...

Ok then here it is I am importing a Excel sheet into access then reformatting it. But one thing I need to do is after I import before the reformat is I need to change the data type on one row from number to text using ether some code or a macro as it needs to be automated. Any idea’s Jez

Ok then here it is I am importing a Excel sheet into access then reformatting it. But one thing I need to do is after I import before the reformat is I need to change the data type on one row from number to text using ether some code or a macro as it needs to be automated. Any idea’s Jez

What graphics can be imported into flash and what are they saved as once they are in the project