i have a colum of cells that depending on a vlookup are either empty o
have text. I want to put these cells in a combo box but i don't wan
to have all the empty cells. the only way i could figue was to us
only problem is i have over 600 cells i want to do this with. so i
there any way to do this that i'm not thinking of without the typin
hope someone can hel
Neuther's Profile: http://www.excelforum.co...Vlookup based on multiple criteria
I have 2 workbooks:
Workbook one: Account number, name, January to September + total
(columns A9 to L240)
Workbook two: I need to populate with data from Workbook one
Column A has the account numbers
all accounts that contains department 71(xxxxx-71-xx) must go to
location 1 (Jan - column B, Feb =96 column E etc)
and all others goes to location 4 (Jan =96 column C, Feb =96 column F
Is there a basic a VLOOKUP or other function that can automatic the
Thanks in advance.
Account Number Jan-10 Feb-10 Mar-10
41001-71-01 6,000.00 - 1,000.00
41001-71...value of value of a variable.
I tried searching, but no use!
I have a Const NameA = "BLA BLA"
I have a variable NameB
Value of NameB is NameA.
How do i get the text "BLA BLA" from NameB variable
Is there anyway to do that?
something like,, VALUE(NameB)
Thanks & Regards
Dim NameB as String
NameB =3D NameA
in a cell you could have
range("A1").Value =3D NameB
would now have content "BLA BLA"
On May 21, 12:35=A0pm, Joe <joe.varghese.j...@gmail.com> wrote:
> I tried searching, but no use!
> I have a Const Name...how to automatically run a report with parameters and email the report based on
I have a report which uses a username as an input parameter.
I need to schedule the report to run automatically and email only the page of
the report which belongs to each user, to that user's email address.
The stored procedure I'm using for the report already uses the username as an
The problem is that I cannot automatically run the report for each of the
parameter values separately.
Thanks in advance...
...populating sheets based on data from parent sheets
I have learned much from the contributors here...many thanks.
To have one spreadsheet (master) trigger the populating of another
spreadsheet (sheet2) when data is entered into a cell on the master
sheet. Once certain data is entered into a cell on Sheet2, it would
populate data onto sheet3.
For example: When a date is entered into the "scheduled delivery date"
field, on the master sheet. I would like for this to "trigger" chosen
data to be entered into to the "delivery data sheet".
Once a delivery has been confirmed (by entering a date int...Conditional Formatting based on Formula
The built-in rules for conditional formatting (greater than value, less
than value, etc) work on the cell for which the CF is applied WITHOUT
having to specify the cell.
The examples for advanced rules using a formula require the formulas to
respect their arguments. For instance, I'd like to have a CF that
highlights numbers, so I'd rely on "ISNUMBER()" to get a true/false
value that triggers the format. However, ISNUMBER() requires an
argument, and I have been able to enter the cell's address as an
argument to get it to work: apply CF to $A$1 by entering "=I...Deriving a name from variables
I have 22 CheckBox objects named CheckBox1, CheckBox2 etc. I would like to
substitue a variable to represent the name in the expression
"Sheet2.TextBox1= False" by using a do loop and varying the number portion
of the word TextBox. Any suggestions?
Checkboxes and textboxes from the control toolbox toolbar???
I'm not quite sure what you're doing, but maybe this will give you an idea:
Dim iCtr As Long
For iCtr = 1 To 22
.OLEObjects("textbox" & iCtr).Object.Enabl...How to fill fill a column with numbers, beginning at number X, counting up.
I simply need to add numbers, beginning with 15,347, (counting
upward), to a column with empty values in a table.
Is there an easy way to do this, rather than completing it in excel
and importing it, then attempting to update the table?
Thanks for any suggestions.
While I cannot imagine a legitimate use for this, the following code will
insert rows starting at 15347 and going to 22000
Dim dbCurr As DAO.Database
Dim lngLoop As Long
Dim strSQL As String
Set dbCurr = CurrentDb
For lngLoop = 15347 To 22000
strSQL = "INSERT INTO MyTable (MyField) " & _
"VALUE...Converting variable text strings to numeric
I've imported some word tables into excel, the 'numbers' have spaces instead
of commas and consequently are read as text.
The 'numbers' vary from single integer to millions
1 101 335
While I can use the left, mid and right functions for the millions that
formula is unworkable for other numbers.
Any ideas, or do I have to get a VB programmer to write a function for me?
Try using Find/Replace
Select the range
Find What: enter a space by hitting the space bar
Replace With: nothing...grouping mails based "read" status
I want to group mails based on the read status. UnRead mails should b
one group and read messages in another group. I searched for th
"Customizing Views", but I could not figure.
Any idea from the group?
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
I don't think you can group by read status. You could sort by the Icon
MVP - Outlook
*** Messages sent to my e-mail address will NOT be answered -- please
reply only to t...Applying GPOs based on Operating System Version (item-level targetting)
we have a Win2003 AD with one server acting as the PDC and a small bunch of
GPOs. All clients are running WinXP SP3. The whole network / AD is well
Our management now wants Windows 7, but only on their computers, we're
getting a WinXP/Win7 mixed environment (thanks Boss!). Thus we have to split
some GPOs (eg. Folder Redirection, etc.). We could clone each security
group, one for XP users/computers and the other for Win7 and apply GPOs only
to the correct group but that might not be the best solution.
We would like to use the item-level targetting like in dri...Auto fill drop down boxes
Is there a way to delete a name that appears twice in a
drop down auto fill box?
This should not happen. Each item in the dropdown list should be unique.
What probably is the poroblem, is that some of 'apparently the same' entries, maybe have a space after the last character.
Try the Trim function on your data.
"Fred" <email@example.com> wrote in message news:firstname.lastname@example.org...
> Is there a way to delete a name that appears twice in a
> drop down auto fill box?
Outgoing mail is certified Virus Free.
Checked by AV...Calendar Formatting Based Upon Multple Date Ranges
Hi there, what I am after is simple enough in nature, but seems to be
difficult to create. Basically I work on a rotational job. Usually it is 4
weeks at site, and 4 weeks off. Sometimes that can Change to 6 on, 2 off,
etc. I'd like to create a calendar that allows me to specify a start date, #
days on, # days off, and have it format a calendar with simple colors for
days working. I don't care what has happened up to this point in the year -
just from the 'start day' forward. any suggestions would be appreciated.
http://spreadsheets.google.com/ccc?key=...Move a dialog based application without the title bar
I have created a dialog based application without a title bar, and
want to move the dialog using the left mouse button.
I tried MoveWindow nut the window was streching instead of moving !!!
Can anyone help me please?
>I have created a dialog based application without a title bar, and
>want to move the dialog using the left mouse button.
>I tried MoveWindow nut the window was streching instead of moving !!!
MoveWindow can resize and move the window, so you've got a coding
If you use SetWindowPos you can specify the SWP_NOSIZE option to have
it ignore the cx & c...Set FormName with variable in VBA
Hi there ,
Maybe the subject is not clear , but i'll try to explain here.
I'd like to change the formname in the next code with a variable :
ex : Forms!FrmOrders.Controls("CmdAdd").Caption = "Add"
change it in : Forms!VARIABLENAME.Controls("CmdAdd").Caption = "Add"
I get the formname from a table/query
I tried to do this , but it always gives me an error.
Can anyone help me with this.
Hello again ,
I've just read the HELP (F1) in Access , and found the solution there.
Just use brackets around the variablename
What is the correct syntax for using the SessionClass.Variable property,
specifically to set it to a particular value so I can then use this value in
another add-in that fires later
...Create a report based on information from two forms
I need to create several reports which have the appearance of the forms in
The top half of the form/report contains information that must be on every
report so I created a base report. In the top half, I have formulas which
are correct. This report/form is called Students.
The bottom half of the form is in reality a subform. What I've done is
saved the forms as reports (using the same file name except that these names
start with R for report),
Then I saved the R-Student report with a new name so I can combine the
information for the second half. (...Outlook rule based on value NOT in name?
I have a lot of SPAM coming in with the sender's address set to my e-mail
address. However, the name is different. I would like to setup a rule like
If the sender's e-mail address = XXXXXXX, but the sender's name <> YYYYYYYY
then move to the junk folder.
Can this be done? All I see are rules to look for a string - not look for
the absence of a string.
I use e-mail to transfer notes to myself and also transfer information
between mail accounts and computers, so I do send myself e-mail fairly
I'm using Outlook 2003.
Thank you for your time!
-...Creating calendar based on agency program data
I am working with a group of social service agencies, who want to create a
joint community calendar of programs.
Their vision is to have a calendar with programs coded by age group, time of
day, day of week, and other information.
i could easily group this data in a simple Access database and produce a
simple report, but they want the output in a visually useful way, such as a
Can one produce a calendar report based on data in a database? We would
need to keep this data constantly updated.
...Creating Formula with Embedded Variable ID
I need to create a single formula for my workbook that references cells from various tabs (over 20) in another workbook.
I want to copy this formula into multiple tabs within my workbook.
My workbook and the external workbook have the same number of and identically named tabs.
I want to embed a variable into the formula that will take on the name of the tab that the formula is copied to.
I imagine the formula would look something like this:
='K:\Sales Reports\[Ohio Team, Mar-21-2004.xls]variable_identifying_the_tab_goes_here'!D1
I know I can use the following formula to derive th...Button on Form to Run Report based on Query with Parameters
I am busy working on a stock control database (and job control).
When I have a Form Open, it shows several fields, including JobID (Which is
the PK for that job) (frm_Invoicing)
I also have a Query that when Run, it prompts for the JobIDNo.
I have a report based on that query. (rpt_CustJobsInvStock)
I have added a button onto the form (onclick -> DoCmd.OpenReport) to open
and automatically print the report,
But I just cannot figure out how to get it to get my JobID from the form,
and to Automatically add it as a Parameter for the que...VBA Filter (with many variables) and copy result to new Worksheets
Using XL 2003 and 97
Two columns (fields) to be used to filter
For Data set #1:
(Choices are numbers and ALL need to be considered at once)
From 4142 to 4143
From 4500 to 5001
From 4509 to 4512
From 6000 to 7000
4122, 4125, 4161, 4177
I do know how to VBA-code a two column (field) filter.
That said, how do I handle the multiple ColumnB possibilities? In reality,
there are 23 more Emp#'s than I listed above.
I know that there is a limit (7?) to variables includible in the AND and OR
There ar...internet based services policy
Today when i opened money i got a pop-up about microsoft money 2006 internet
based services policy. I click Decline because i don't want it and i don't
want microsoft to "from time to time without notice automatically install
updates" and MONEY CLOSES!!!! WHAT THE HELL!!! I can't open it without
...How do you add based on base 60 (minutes) instead of 100
Want to add a column with hours and minutes as 5.32 meaning 5 hours and 32
Enter it in time format, 5:32
Make sure that the total cell is formatted as [hh]:mm to cater for more than
"Mick Stohr" <Mick Stohr@discussions.microsoft.com> wrote in message
> Want to add a column with hours and minutes as 5.32 meaning 5 hours and 32
array ...Fill Colors in Publisher 2000
Fill colors dissapear. I am using a calander and in some dates I am filling
in different colors. For the most part it works fine, but occassionally when
I go to fill in a new date all the dates filled with color lose their color.
This will also happen with colored text as the test will default back to