Hey guys, I've recently been playing a lot of online poker (exclusively tournaments at the moment)and wish to track my results. I have all the raw data and have started building my spreadsheet. However it is quite crude at the moment and I will require some help throughout the process. Attached is what I have so far.

I have a list of part numbers, and the associated onhand quantities for these numbers in the adjacent cell. I need to create as many copies of each part number as there are onhand quantities in a list, including all of the part numbers. So if there are 3 of part 123, I need the column to have 123, 123, and 123 in each corresponding row below the heading (A2, A3, and A4). If the next part number in the original list is 456 and there are 5 on hand, I need the rows A5, A6, A7, A8 and A9 to have 456 in them, and so on. Is this possible?

(Sorry, I originally posted this in the wrong spot)

Dears,

My question is little complicated, maybe it will take time for you to read all below but I would really appreciate your help on this.
The thing is as you may see in the attached file there are some rates are there with the country name & zones, so what we have to do is to get the rates from the file but before that we need little calculation like ( there will be a multiplication of 1.18) and it takes a lot of my time in calculation and I want to make it easy but don’t know where to get started.

Hi there would really appreciate any help. I was wondering if there would be a modification to help me search only .pdf files in a folder. I've had a look at other vba which finds just pdf but can't find any that looks into subfolders as well so would like to utilize this one as its extremely comprehensive but add in specific file type section if possible. Im new to VBA so any help would be greatful

Option Explicit

Sub pass()

Dim user As String, pass As String
Dim rguser, rgpass As Range
Dim found As Boolean
Dim x As Integer
Dim newpass As Boolean
Dim yesno As String
Dim i As Long
Dim passpos As Range
Dim rowuser As String

Set rguser = Range("a1")
Set rgpass = Range("b1")
found = False

user = InputBox(" please enter your user name ")
pass = InputBox("please enter a vald password ")

Do While user = "" Or pass = ""
MsgBox ("you have to enter a valid information ")
user = InputBox(" please enter your user name ")
pass = InputBox("please enter your password ")

Hello,

My level is the level before pre-novice. I'm having a great deal of difficulty trying to create a drop down list that will activate a subroutine once you select one of the numbers 1-15, and you can keep selecting various numbers 1-15.

This is what I have so far:
I've got the drop down list completed (numbered 1-15)
And the code below (I'll finish the rest of the cases when I can get these two working)

Private Sub ShowSaleComps()

ActiveWindow.DisplayZeros = False
Application.ScreenUpdating = False

Select Case NumSelect
Case 3
Call Show3Comps
Case 15

I am having a situation while writing a function in excel VBA.

a variable is having a long string as below:

test = "jhon~Pass, kareem~pass, lacy~fail,Jenat~pass, milo~fail"

I want to store name in one array and the corresponding result values in another array.

Please help me, how it can be done?

Hello All,

I have tried changing the background color of multipage within the user form. But there is no properties option to change the back color. Please help in changing the back color of multipage.

Thanks and Regards,
Mythili S

Using a VLookup formula, I need to change the value that displays when my condition is not met.. its currently set to #N/A.. I need it to display "YES" adding ad If statement is creating a circular reference.. (not sure why).

thanks

how to change zero to dash?
some of the excel table information have no information, so i insert zero for that column. can it automatic change to dash?

I am receiveing RUN-TIME error 424 - Object Required errors when using nested functions within my EXCEL VBA Code.

The code is attempting to read a text string and extract 3 characters from within that string.
There are 4 possible sets of character outcomes I am looking to obtain.

When I embed the formula within a spreadsheet cell it works. It does not work within the VBA code.

Here is a sample of my code:

Sub MacroSearch()

Dim Res As Variant
Dim FName As Variant

FName = "Application.WorksheetFunction"

I need an excel expert that knows a shortcut that will allow me to convert the follwing formula =+'[Wexford MD Staffing Audit Phase I Oct 2012 x.xls]Staff Plan - FY13'!L181+'[Wexford MD Staffing Audit Phase I Oct 2012 x.xls]Staff Plan - FY13'!L317 to =+'Staff Plan - FY13'!L181+'Staff Plan - FY13'!L317

Hi all,

I have registered to this forum mainly because I have an issue which I cannot get sorted.

I use CMS Scripts from Avaya for export a file which is saved as .xls, but in fact it is a HTML file.

I use these reports to extract daily information which then populate another file which has the monthly data.

My issue is that because the file which is generated by the script is not in 'real' .xls format, when the formulas in the monthly file try to populate the fields, no information is found.

Hi. i am trying to create textboxes during runtime, and then naming them.

I have managed to create a single textbox during runtime, however, i cant seem to name it.

what i am trying to do is to create a number of textboxes during runtime, and name them each differently, so i can store values into them.

For i = 0 To 5

Set txtB1 = Controls.Add("Forms.TextBox.1")
txtB1.Name = "chkDemo(i)" ' after assigning name to txtB1, i couldnt seem to include values for the new name
chkDemo(i) = "hihi" ' error appears on this line

Next

TRADEMAGIC
Please check the file
I am not aware of VBA programing but use Excel to its fullest( or at least so I think !) ... I am trading on the stock exchange( and needless to say loosing !), but I am sure that if someone can make this code .. I will not loose ! Please remember that Live values are always changing fast.
Please help me if you can ... I will be highly obliged.....it is a very difficult task as much as I can envisage ! BUT it could be a child's play for a Veteran !

Question1
How to know the URL is insert in which column?
http://i.imgur.com/tuXLU.jpg

Question2
How this excel get the stock code? Entering different 4 digit in B1 will change the data.
I know it can check the url in edit query, but how it set get different data?
http://i.imgur.com/HQOMo.jpg

Sheet1 has a list of times in a column in sequence from 8:00am to 9:00pm in half hour intervals.

Sheet2 has a list of times in a column with additional data in the rows. The times on sheet2 are random.

I would like to copy the data from sheet2 from each time into the corresponding time row on sheet1.

Hi,

I hope someone can please help me, this happened to me before and for the life of me I can't figure out what I did to fix it. I am creating a formula in a cell but when I hit enter the formula shows instead of the results. I will tell you what I have tried already:

* Format cells and change to general, number, text... nothing works there
* Copy/Paste
* Create formula in another cell

Please help!!

thank you,

Carmen

Hello All,

Sorry for the long description of the

requirements, need your help in below

situations; Where i want add Buisiness

Hours/Days to get the Target Date.

Working hours: 8:00 AM to 19:00 PM

Urgency Type:
ND (Maximum 1 Day 11 hours)
3D (Maximum 3 Day 11 hours)
4D (Maximum 4 Day 11 hours)
5D (Maximum 5 Day 11 hours)

Threshhold - 16:30 PM

Weekends to be Excluded.

Holidays to be Excluded based on

Country. Say I have 2 countries India

and America, where America has holiday

on 12/24/2012 but India does not have

Can you help me regarding on this?
I have excel work book with function add and search.
i want to modify it.Unfortunately, i am still a beginner.
Some of the codes here are from other forums, i modify some of those codes.
here is my problem.
"Add" function, if there is duplicate on the data to be add. Message will pop-up "already existed, Do you want to update?". if user opt to update, program will update the existing data on "database sheet".

Hi,
***************************
Answer for olivier p beland
***************************

Oliver, you will find the attached file like I promised you...
You will have certainly to complete some instructions.

Have nice Christmas

Hi all,

I am looking at code that will help me automate the emailing activity.
The requirement is below
* a sheet contains few details of invoices that are on hold.(sheet attached for sample)
*invoices may be on hold for different reason and are identified by hold code
*Different invoices may be on same hold code.
*treatment of each item on the sheet is based on the hold code.
*I need a code that sends emails to listed recepients based on the hold code.
*subject line of the email is standard and is avilable on the spreadsheet

I have an Excel file I downloaded from another forum. It is not my work. It generates a schedule for my 8 Ball league. I can input the # of teams and the number of weeks in the session, hit "generate" and I get a fairly balanced home and away schedule. I need to tweak the schedule, because some of our venues have more than 1 pool table and multiple teams, so there is an over-booking possibility to deal with. Also, we would like the schedule to pit most of the stronger teams (for ex. the top 10 or 12 teams from the previous session) against each other.

how this excel file get the table information from this website,
i can't find which cell adding the url,

when i disconnect my line, it showing can't connect to http://dj.mybank.com.tw/z/zc/zch/zcha_2330.djhtm.
so i need to know which cell is entering the link above.

Hi, I want to do a userform allowing users to create new "projects", each with a number of "milestones" and targeted completion dates for each milestones.

Right now, my userform allows users to (1) give the name of the new project (say "temp") and (2) give the number of milestones (say "x"). These are inputed in a data table with "temp" repeated "x" times (i.e. over "x" rows).

So I have been building a new report and I have been asked to add an additional item that is messing with my automation of the workbook

If Sheet2 Cell Hx = y then copy Sheet2 Cell Ax, Bx, Cx, Dx to Sheet3

To help understand what I am working with I have VLOOKUP formulas pulling the information into sheet2 in cells B & C, Drop down menu in A and general text in D. Each row is a person with information about them in that row - I only need the above referenced cells to be copied to Sheet3 in the event that cell H = "Accepted Offer"

Let's say that I have two workbooks: FileX and FileY. (both .csv files) I am looking to create a Macro that copies from a certain cell in File X to a certain cell in File Y. This would be done based off a query.

Example:
The query compares all values listed in Column A of FileX to all values listed in Column A of FileY. If the value matches in column A in both files (let’s say: IF ID = 5), it then retrieves information from Column J of FileX for that row and pastes it in the corresponding row of FileY Column J.

Is this possible? And if so, how could one do this?

I am trying to construct a conditional formula to do the following:

Calculate the number of days between 2 dates. If cell A1 (starting date) is blank, then return "0". If cell B1 (end date) is blank then return the number of days between A1 and today's date.

How I can change the format of many many rows columns depending on a given number in a table and join with the ID which is related to the table?

I have a register in which ID is assigned one or more models of a product to one or more connectivities as the example in the following template:

ID, EFT 930, ICT 220, DATE, DIAL, DIAL ETH
7070707, 1 , 2, 08/11/2012, 1, 1

" I want to run the code in batch file in VBA without having to run batch file "

mean that i want use the command that get same result from batch file in VBA

So i dont have to use batch in my work , only use VBA to run CMD and run the command line or some Solution similar

i have try but i just new to VBA and programing ,i need some help T^T

here the code

this is from batch

--------------------------------------------------------------------------------------

@echo off
>summary.txt (