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...
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...
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...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.