Hi All,

I need to update a drop down based on previous cell..

for example
In sheet 2 i has

product name version

a 10
a 11
a 12
b 10
b 11
b 12

and in sheet 1 as

name version as two columns and if we give name as 'a' then version should get a drop down showing all versions of only product 'a'

if name as 'b' all versions of only product 'b'

its an urgent plz help..

Hi All,

I want to auto fill a column value based on values of three cells.Currently i m using vlookup for this but it is taking only left most column.So, is there any other way to do this.

for example

product name,version,size,rate

rate column should auto fill after selecting product,version and size using drop downs.

I have table in other sheet containing all these details.

I have a large excel workbook (in Excel 2010) with more than 6,000 named cells. I would like to write a function that sets the cell value equal to the cell name.

I thought the following would work:

Sub FillNamedCells()
On Error Resume Next
For Each c In ActiveWorkbook.Names
Range(c).Value = Range(c).Name
Next
End Sub

Unfortunately this is returning the cell address though. I can't seem to figure out how to get it to return the cell name. I'm wondering if I need to change a setting. Can someone help me out with this?

Thanks!

I managed to create a macro to show the following:

If (I3<>0,I3*G3,H3*G3) and this repeats itself for cell N3,R3, V3,Z3 ETC.

Option Explicit
Sub Eg()
Range("J3, N3,R3, V3,Z3,AD3,AH3,AL3,AP3,AT3,Ax3,BB3,XF3,BJ3").Formula = "=IF(RC[-1]<>0,RC[-1]*RC[-3],RC[-2]*RC[-3])"
End Sub

Let me explain a bit more how this should work:

This report needs to be downloaded from an application.
The macro needs to be attached to this report so that when I download the report the macro automatically runs this formula in the appropriate columns.

Hi Experts,

I would like to create multiple graphs (one for each item of a pivot table filter), without the annoyance of generating a pivot for each chart. If the chart data update with the pivot table and/or it is possible to automatically generated the array of chart is a huge bonus.

The following image tries to illustrate what I'm talking about :)

Thanks in advance,
Fdiang

HEY,

I HAVE EXCEL 2007, THE PROBLEM IS WHIT CONCATENATE FUNCTION.

WHEN I'M DOING =CONCATENATE(999711100100,300,10196) I GETTING THE NUMBER
99971110010030010196

so far so good, but when i'm doing on the number f2 and then f9 and then enter (convert it to a number) ,i'm getting adifferent number (99971110010030000000).

i must convert it to anumber becaue i want to do on this number a vlookup function.

can you help me please?

thanks.
efi

Need help quick please !!!!

I have a file where I save all my invoices (new one are added as sales happen) an dI have a spreadsheet where sheet 2 summarises the sales in lines, for example:

Invoice 101
Date 14/11/2012
Cusomer John Smith
01 blue pen $1.00
02 erasers $3.00

Spreadsheet (summary):
Invoice Date Customer Qty Description Price
101 14/11/12 John Smith 1 blue pen $1.00
101 14/11/12 John Smith 2 erasers $3.00

I have made two user forms. Both I have up on the screen.
What commands do I use to switch between the two
while leaving them both up.

Seems like the program freezes as soon as I open the second form

I am using Excel 2003.
Thank You

I have created a blank invoice and have all of my inventory items in a separate tab but am having trouble with the formula to auto populate the cells. I have followed the exact instructions for vlookup and I am just getting a "0" in my fields. I have attached the template if anyone can help. I am building this for my nonprofit because we have changed database systems and our new system does not print invoices. Thank you so much.

i'm very sorry that i cant find the right english words to explain for this problem (i'm foreigner)

this is my question how can i import it to another sheet (in same worksheet) as a nice table.

what i need to use VBA or Fucntion

Thank You

One workbook, one data file, lots of Pivots off the same data file.

When I move between worksheets I get corruption in that previous worksheet is still partly visible "behind" the worksheet I now want to look at. No VBA, No Macro's - any explanation / cure? Think it's v2007.

Hi All,

I am trying to run a nested IF so that the price for a product is zero if not launched, then it is full price for 2 months followed by half price for 3 months, thereafter it falls to minimum price, and stays at this price until it the product ceases. Prices ar $1.99 full price, $0.99 half price and $0.69 thereafter.

The code I enter (and tried different permutations) gives me full price followed by minimum price, but I cant get it to give me the mid price. I know this maybe an obvious error, but I am now going round in circles on this one.

Almir...

Please find the appended revised Query sheet.

The cells next to the 1st appearance of those 10 tiffs have to be filled with the 1st Element (Borrower) from sheet-3.
Cells next to the 2nd appearance of those 10 tiffs have to be filled with the 2nd Element (Lender) from sheet-3 and so on.

Manny's VBA script works but is there any way without getting into VBA script?
Please advise.

My curious quest to learn VBA scripting is still left unanswered. Could you please share your ideas.

Thanks & Regards
Kumar.

here the text file example i want to grab only the line head with "lsb.ibm.kbank"

dadadadadadadadadadadadadad hahahahah stupid me stupid me stupid me stupid me
lsb.ibm.kbank:FinCheck:050112:AIX:6.3.2:fhgt.dll:dserver1:198.168.65.108:C:F:FC SCSI:user1
lsb.ibm.kbank:FinCheck:050112:AIX:7.3.1:aserver1:fhgt.dll:178.168.65.188:C:F:FC SCSI:user3
hahahahahahahah crazy crazy no skill i'm suck toobad lksdjflskdhfsdkfj bla bla bla
dadadadadadadadadadadadadad hahahahah stupid me stupid me stupid me stupid me

would appreciate your help
please refer to the attachement

thank you guys

When I copy a cell and drag down to copy the result is always the same as the first cell, how is this possible?

Okay, so I'm stuck working with Excel 2003. I'm trying to get one cell to auto fill with the date and another with the current time when something is scanned into the spreadsheet. I keep getting circular reference issues/errors and the formulas break. The one I've been using for the date is this one, time is basically the same only NOW:

=IF(B137<>"",IF(C137="",TODAY(),C137),"")

Help please, I'm tied up with other things and don't have forever to search and find formulas more problematic in this old version than what I'm used to working with...

i want to get some information from text files and import it to each cell on table

*i try it and came out that everything is in a cell*

this is example of my study text file (my real project is more complicate than this)

dadadadadadadadadadadadadad hahahahah stupid me stupid me stupid me stupid me
lsb.ibm.kbank:FinCheck:AIX:6.3.2:dserver1:198.168.65.108:C:F:FC SCSI:user1
lsb.ibm.kbank:FinCheck:AIX:7.3.1:aserver1:178.168.65.188:C:F:FC SCSI:user3
hahahahahahahah crazy crazy no skill i'm suck toobad lksdjflskdhfsdkfj bla bla bla

Hi! i am stuck in this problem:
1) I have a column with about 200,000+ rows in Excel 2007, and need to
somehow get this transposed into a row (so with 200,000+ columns). I have
tried to do this with the TRANSPOSE function using Ctrl-C and using the Paste
drop-down menu and selecting the Transpose option. But I get an error message
that the copy area and paste area are not the same size. I presume this is
because I cannot paste across 25,000+ columns due to column capacity of
office i.e 16384 :( The thing is that i have to transpose this data in excel

Hello,

I'm working with a excel spreadsheet of current contracts our company has with providers. Basically, I need to set up a system where I am notified when a current contract is ending (approximately 6 months prior to an end) so that we can reach out to the provider and possibly re-negotiate. We work with Outlook so I'm sure an e-mail notification would be okay, unless anyone can suggest a better process for being notified. So my questions are:

1. What would be the best process in Excel for receiving notifications for contract endings?
2. How do I set this process up?

Thanks,

Hi All,

Having a really tough time doing what I was hoping wouldn't be so difficult.

I need to pull a table automatically into Excel but the problem is it is an asp page which pages the results across 10 pages.

Can't figure out how to pull data from all the pages because the URL doesn't change

www.ohchr.org/EN/NewsEvents/Pages/newssearch.aspx?NTID=PRS

Any ideas on where to put my efforts?

Appreciate any help, thanks!

I have a 10 different excel files with VBA code in them. If I make a change in one of them, I have to manually change the code in the other 9 files the have the same desired effect. How can I make it where all of the vba source code changes in all of them when I make a single change to one of them?

adam

Hello,

I have a question regarding creating macros whereas the scenarios as follows:

Sheet1
Upon clicking any cell in Sheet1, it will automatically filter based on cell A and B.

Sheet2
Automaticall display filtered criteria based on double click from Sheet1

For example: when I double click on C1, on Sheet2 will automatically diplay filtered data based on A1 and B1 and same thing goes to if I double clik on C2 on Sheet2 will automatically diplay filtered data based on A1 and B2.

Really need help from the experts here.

Thank you

I have a spreadsheet where each tab is a new invoice and a second spreadsheet where sheet 1 summarises all invoices (Invoice No / Date / Item / Price)

I'd like to know if there is any formula (maybe vlookup) that I can use to bring the information from each invoice automatically to my spreedsheet 2

Or should I use macro codes ??

Thank you !!!

Open up the attached sheet, and go to the April sheet. This is the finished product; I did a paste special to paste only the values once the functions were done calculating. On the left is the report I want to generate, and the right side of the screen is my raw data. In the May and June worksheets I am using my own variation of dynamic ranges, by having each cell in my report reference the cells M2:U2, and as each month of raw data changes, I simply change the contents of m2:U2 to reflect the changing raw data.

Hi,

I have an excel sheet provided by X . I want copy all the sheets which contains the data from X to Y which is having VBA code.Can you please help me to help me out.

I'm now little (Sad) boy intern in IBM company. they gave me to do " VBA excel that collect information of which AIX server of my client is not support which version of patch. i have problem on Excel side but on Shell Script i will find the way later

the main thing is i want to "learn" how can we collect the files that have same name and show result in the excel tabel and just grap some line of version information from each (text)file to compare with the version of patch

I need the Light that show me what i have to study, to practice, i really have no clue here.

Hi All,

I have come up with an excel file [Excel 2007] where the sheets are designed to process some business related information.

Im looking for ways to hide the sheet forever from end users.

The options like Visible property can be broken using VBA code.
Is there a way, i can hide the sheet and its contents from end users.
Thanks in advance

Hi The_Barman,

I am so confused..
can not find date and time picker on vba user form.

do you have any idea ?

Regards
Nipendra

Hi
In a spreadsheet with multiple sheets I am in [sheet 1] and need to know the name of [sheet 2] (or any other different sheet from the one I am) to include it in a formula.
Thanks.