Hi,

This is my first post so may i say thanks for any help received.

I have got a list of 320 product codes that need organising so i can complete a "related items" database.

so for example, the new york range of products contains the following codes:

example-3202
example-4038
example-1048
example-5827

in order for my database to work i have got to format the products as such

example-3202 | example-4038
example-3202 | example-1048
example-3202 | example-5827
example-4038 | example-3202
example-4038 | example-1048
example-4038 | example-5827

Hi

I have found some vba code which automatically sends an email via excel 2010 through lotus notes. This works perfectly with one annoying exception. Each time I run the code, I receive the following lotus notes pop up message "file\Automation-Embedding.nsf does not exist" at the following points in the vba code:

Set NSession = CreateObject("Notes.NotesSession")
Set NUIWorkSpace = CreateObject("Notes.NotesUIWorkspace")

Could you please help me in finding a solution for tracking the changes in an excel made by list of users in a Shared work book for the data entered in the past.

Good day
I have tried using the =cell("address") function with no success, I was under the impression that when entered in to a cell it would return the cell reference of the last cell to be changed,what is happening is it is returning the address of the cell that the cell function was entered in. This function would be very useful in a spread sheet with a lot of data, I am sure there are other means of doing this but the cell function should do it nice and clean and simple

Hello friends ,
Can anyone help me ,

i want to make a button in excel sheet.
When i will click that button the text "Button value Copied" will be copied in the clipboard.

Can any one write some code for that button??

I have made a userfrom and populated it with data. I want to import that data created into a spreadsheet.

I am trying to input a date into a cell and I want it to repeat the date in cells below. I want it to repeat the first date I enter into the column in the same box in different tables. EG

01/08/12 in cell B3

and then I want this date to repeat in cell B13, B18 for example. Then when I type

03/08/12 in C3 I want it to repeat in C13 and C18.

Thanks

Nat

I need to translate / understand the following macro in simple english step by step of what it does and how it works.

I am doing a spreadsheet for student grades. There is a limit (30% of no of students) on how many students can get A or A+.

More students get A's based on their test scores than is allowed, so I want to know if there is a formula (to put in Column D2 below) to automatically reduce the A scores of the students over the 30% limit down to B+

Example

There are 20 students in a class but only 6 can get A and above.

However 8 get A scores on their tests.

So I need a formula to reduce the two lowest A scores outside of the 30% range.

Hello, This is probably a simple issue Im just not well versed in excell.
I am trying to do the following:

I have a master file that a check list. This check list is used for each client.
The list has several columns.
Col 1 - has the task listed
Col 2- Is left blank on the master file to later be filled in on the slave/copy. Such as a date the task was compeleted.
Col 3 - will be a brief description of issues. THis info is handled exactly like Col 2.

I would like to add new tasks to the master file in col 1 and it automatically add the new tasks to the slave/copies files.

Hello All!

I'm trying to write a code which will assign the value of a cell to an array...

Following is my code snippet:

Dim c As Variant
Dim aypartList() As Variant 'array of partnumbers
Dim ayCount As Integer

ayCount = 0

Do

c.Select
aypartList(ayCount) = c.Value 'Type mismatch error 13 shown in this line
' Im trying to assign the value of cell "c.value" to aypartList(0) etc
ayCount = ayCount + 1

Loop

ReDim Preserve aypartList(0 To ayCount) As Variant

MsgBox aypartList(ayCount)

I'd like to know where i went wrong...!!

Thanks a lot in advance!!

Hi Guys,

I am looking for VBA code to search for multiple entries and if those multiple entries are "True" then the code will pass the Answer in a Textbox as "Hired" or "Available"
Basically I am trying to develop a little program for Hat Hire whereby if I enter the Date of when the customer wants to hire a Hat and the SKU Number of the Hat itself the code will check to see if the hat is available on that date by passing the number "1" as true or false etc and display in a Textbox as "Hired" or "Available".

Hi all!!
I need a code in Excel vba to open a folder and select a file and assign that file to a variable of object type.

Please help!!

Thanks in Advance

Expertise level - beginner
Excel 2007

I have a workbook that has several tabs. One tab is my "working" tab. From this tab I want to copy information to "presentation" tab if a cell = "yes". When it copies to "presentation" I need it to look for the next empty row and fill in cells based on the cells in my "working" tab.

I was wondering if I could be given some guidance on how to query some CSV files. I have an online store and have about 4 or 5 suppliers and our store hold about 400 products. I receive stock information daily but it's practically impossible to manually check the contents of the CSV files to strip out stock level, price changes since the last run. In a nutshell, I would like to be able to run a code that will check my supplier's CSV files which will return stock availability, price change since the last run. These 2 information should show in the columns within the worksheet.

I use a software for my company called Team Viewer, which allows me to remotely connect to a customer. Well the sad part is the log file of it is the worst part about it. I've done a lot of work already for this company and retrieved all my log files, but the time is what is messing me up. Below is how it records the time. What would be the formula to figure out total time worked, because I have 245 cells to calculate time for :/

Connection Started: 21:16:15
Connection Ended: 22:03:40

I have a large master data file that essentially lists out training classes and assigns them to particular Lines of Business on particular dates. It is a calendar/scheduling function. I then bucket the information into Quarters (Q1,Q2,Q3,or Q4). I would like to create a separate tab that only shows the classes for a specific block of time(ex. Q2). A training may launch for one Line of Business in Q2 and another in Q3.

Hello, as you can see in doc attached, I have a Chart with vertical axis populed dynamically with OFFSET function.
My problem is the Horizontal Axis, where I need (you can see in the SERIES in the doc) two value (two column date and hour).
If I put in the SERIES the value "$A$2:$B$29" as you can see, two values are drawed in horizontal axis.

I need to use OFFSET also in this axis, so I can add new values and dynamically update the graph.

I don't know How to use OFFSET for two column, is it possible?

P.S. I have attached also excel file :-)

Thanks in advance
Best regards

I have few doubts in terms of adding data lists to a combo boxes based on the filtered excel sheet.

Below are my questions.

Please find attached excel sheet in which I have created a user form with few tool controls. My requirement is as below:

When the form gets activated (or when the excel sheet opens), the "Region" combo box should be filled with the data list. The other two Combo boxes "City" and "Sales Person Name" should be filled with the data list depending on the selection of "Region".

Hi,
Please help me !
I am trying to save excel file as csv semicolon delimited file. While I was doing it manualy (File->Saveas->CSV(commaDelimited)) it worked fine, but with macro it gives me file with commas (without semicolumns)!?
My macro (main part) is:
Activeworkbook.SaveAs Filename:=..., Fileformat:=xlCSV, Local:=True
I set Windows Regional Settings List Separator to ";" (as it was suggested in some Excel forums) but it still wont not work properly :(

Hello all dears,

I have to import a web page data in MS excel.

web adress is: http://www.anagram.cmlinks.com/Derivatives/LatestOI.aspx

I have to condtioanlly import web data to excel
ex: say Individual, option stock, all options, 30 aug 2012, all symbol.
If I give abv condition i get a new page on web , I have to import that particular page to excel.

Please resolve my query and give me excel file if possible.

thannks

Nilesh
India

Hi There,

I have four columns in my Checklist workbook Excel among many more, with formulas associated with it.

The columns are

PreAnaerobic PreAerobic PostAnaerobic PostAerobic
Positive Negative Positive Positive
Positive Positve Positive Pending

So what I want excel to do with these columns is, the date from when I enter , positive ,negative or pending after 10 days it has to notify me that the data is pending in a certain column.

How is that possible? Hope I have not confused everyone..:)

Please help.

Hi,

I have a huge data set (ranging from A1:CH6000)with few date columns. I have some date values which are beyond 31st Dec 9999, so excel is displaying it as "########". My objective is to convert these dates into 31st Dec 99 (12/31/99). I need a macro code for this requirement,my date columns are "J" and "K". Can you please help in this regard?

Please see the attached file.

I'm looking for the column 'Earliest Date' (Column G) to automatically update when the next event is happening. Currently there is a formula in the column which makes it record the earliest date and event happens (an event is marked by an E in the relevant cell). The problem is I don't just want the earliest date recorded I want it to be the earliest date in relation to today's date. e.g. now First Wednesday should be showing July's date rather than still showing May's date.

I'm assuming I'll need code to work this but not sure where to start.

Hi,
I have the following question>

In my worksheet there may be value "X" in some cells of column F. I would like to copy this entire row and the 4 rows underneath to Sheet 2, if this is the case. In sheet2 there should then be a list with all the rows (always 5 rows per X) from sheet 1 with the "X" in column F.

More Details:
It is a client list. Each client information consists of 5 different rows. Where as in the first row in column F is the "X" or not.
The first client have rows 3-8, the second client rows 9-14, etc.

I hope it is not too confusing.

Dear Excel experts,

I appreciate any help for this:
I wish to build a macro to get (Count/Total) for some values in specific columns those related to name in A column
For more details please find the example in attached file

Thanks in advance

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

Can anyone advise..how I can create an ongoing "log" to automatically populate inv#, date, customer, and amount, pulling data from three other worksheets using identical templates (for 1st, 2nd and final invoices). I've attached workbook, so you can see, it's not too complex, but I'm still learning.

Hi, I would like to make a table to the side of my main worksheet to calculate the following from the main worksheet.

Table headers

Date from | Date to | Total value of quotes | Value of quotes won

Date from and date to will be input and used to mark a range or dates from the main table located in column E
Total value of quotes will use the date range and calculate the total value of quotes raised for that time period. Values are located in column O

I am currently running a software that I use for my self employed work that was written many many years ago in access by a friend. I would like to try to convert it / rewrite and add improvemnts using excel as it is now quite outdated and inflexible and is not easy to add changes to it.

Basically when I work on site I need calibrate each product by type, lets say type a , type b type c for aguments sake.

Please help me provide a formula that will change color of data in column A once text "Confirmed" in entered in Column B:

COLUMN A COLUMN B
6/1/2012 Available
6/2/2012 Confirmed
6/3/2012 Tentative

Thanks