Search results for query: *

I have the first couple of rows listing catagories, workers here will past their info into this Template I have. Sometime they accidentially delete one of the rows, kinda screws up things. At home I have XP Office, it seems you can specify certain cells or what ever to be locked down. 97 @ work...

I am using this code to update a sheet once excel is done querying a DB, it gets dumped into the second sheet called Data and there it gives me a timestamp in cell C1. Like it alot but when there is alot of data it will sit there update each cell and update the time stamp. can someone fix it...

If a cell in sheet one is BOLD, then copy and paste entire row onto sheet 2. or a sheet name, Option Explicit Sub TransferDataPlease() Dim i As Long, n As Long n = 1 n = n + 1 For i = Range("A65536").End(xlUp).Row To 1 Step -1 If Range("A" & i).Font.Bold = "TRUE" Then...

I can't post another on the other thread for some reason, max 25 posts maybe. WOW, that is all I can say. I have to say that I love your last set up, selecting the threshhold manually works terrifically. I actually use your work on other information, surprisingly I can use it on addresses, we...

I have been making some buttons Fireworks that I use in Excel. I have Office XP and then Office 97 at work. So at home I create the buttons and add roll over effects, simple ones like the text changing to a different color, or if outer bevel then make it inner bevel on roll over. Any one know...

************this is before Option Explicit Const THEFT_THRESHHOLD = 0.75 Const SEARCH_COLUMN = "A:A" *************this is after, does not work Option Explicit Const THEFT_THRESHHOLD = Worksheets("Sheet1 (2)").Cells(1, 3).Value Const SEARCH_COLUMN = "A:A" Zathras helped me with this one but need...

anyone have experience with flash and excel? i just want to put web type of pull down menus either in flash or html. i seen a software online called xcelsius that combines the two. i have already made buttons in Fireworks and assigned macros for those, does excel have pull down menus??? i could...

anyone have experience with flash and excel? i just want to put web type of pull down menus either in flash or html. i seen a software online called xcelsius that combines the two. i have already made buttons in Fireworks and assigned macros for those, does excel have pull down menus??? i could...

dont know if this would be vb or better as a conditiona b/c i do not know where to start with this one especially. is it possible to detect the fifth ( or fourth, third, etc) digit in a # (8759 6 5687)it is not seperated like that but i want to be able to search a column and.....well this is...

I am having trouble, too many mistakes to paste here. Problem: Column A has a four digit # added each day. That # is divided by the cell next to it (ie: =A6/B6)which the outcome goes into cell A100. It is done manually every day, along with a million other things. Each day the cell below the...

=SUMPRODUCT(--(MID(A$1,ROW(INDIRECT("1:"&LEN(A$1))),1)=MID(A2,ROW (INDIRECT("1:"&LEN(A2))),1)))>=5 this formula will put a condition on the cell if it matches "x" amount of digits. how can i get this to recognize any cell, or at least a few up or down instead of just the one cell. possible??

=SUMPRODUCT(--(MID(A$1,ROW(INDIRECT("1:"&LEN(A$1))),1)=MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)))>=5 this formula will put a condition on the cell if it matches "x" amount of digits. how can i get this to recognize any cell, or at least a few up or down instead of just the one cell. possible??

i can not figure out how to get this code to delete both rows that are the same instead of just the one. Sub RemDupRows() Dim lastcol As Integer, lastrow As Integer, i As Integer Dim j As Integer, k As Integer, matchfound As Boolean Dim rowMatch As Boolean Application.ScreenUpdating = False...

=and(a2<=a1+10,a2>=a1-10,a2<=a3+10,a2>=a3-10) I am just trying to get a cell in a column to high light if it is "X" amount more or less that the cell. it would be ideal if someone could help me with doing this in VB which will save me on file size. but fat chance there, so can you see what is...

I have a spreadsheet that gives a timestamp when the sheet is updated. There is a button on the first worksheet that queries a DB and populates the data in the second worksheet. If I put this code on the data worksheet then it becomes real slow due to updating the timestamp when each cell is...

=and(a2<=a1+10,a2>=a1-10,a2<=a3+10,a2>=a3-10) i have this formula that will look at the cell above and below to see if it is within "X" (10) amount less or more than in that cell. does anyone have a script that would resemble this effect? i am just recently getting familiar with VB, which does...

I use Access to create queries for information on product that is presented on a regular basis. I need to add an element for time to determine if 2 products have been presented greater than 1 time, only list them if there were done within one hour. I usually query for Date, time, location...

I use Access to create queries for information on product that is presented on a regular basis. I need to add an element for time to determine if 2 products have been presented greater than 1 time, only list them if there were done within one hour. I usually query for Date, time, location...

In this site that I came across the other day, the button are interesting. I can't think of or have done this before so that is why I am asking. The three main buttons, are they in a MC or what. Because once you click on one, you can't click on it again at all. I have just never designed any of...

i am having a hard time understanding something about sql and how it works with a flash form i want. a friend of mine will be doing the DB and i am going to work on a flash form. this form will not submit any information, instead it will GET information and populate about 5 fields. on my...