Re: $$Excel-Macros$$ Macro to sort data in Ascending/Descending order

Sub sort_ascending() Dim Temp As String Temp = ActiveCell.Address x = Mid(Temp, 2, (InStr(2, Temp, "$") - 2)) If ActiveCell.Column <= 6 Then Sheets(1).Range("a1:f" & Range("a1").End(xlDown).Row).Sort key1:=Sheets(1).Range(x & "1"), order1:=xlAscending, Header:=xlYes End If End Sub Sub sort_des()

$$Excel-Macros$$ Macro to sort data in Ascending/Descending order

Hi All, I am working on a excel with data in many columns. I want to add two macro button on each heading to sort data, one for Ascending sort +and second for Descending sort. Is it possible with macro. I have attached the sample sheet. Please advice if it possible. Regards, San --

$$Excel-Macros$$ Email Macro Based on an Address in a specific Cell

I use a file with a macro (which this wonderful group collectively contributed to) which when I highlight a range and hit ctrl + s it drops it into a new excel file, opens outlook and addresses it to the addresses in the macro. I would like to let the user put an email address in a cell and when t

$$Excel-Macros$$ Re: Lookup values in different sheets

=IF(ISERROR(VLOOKUP(B4,$E$3:$F$3,2,FALSE)),IF(ISERROR(VLOOKUP(B4,$H $3:$I$3,2,FALSE)),VLOOKUP(B4,$K$3:$L$3,2,FALSE),VLOOKUP(B4,$H$3:$I $3,2,FALSE)),VLOOKUP(B4,$E$3:$F$3,2,FALSE)) On Jan 25, 10:57 pm, Aamir Shahzad wrote: > Hi experts, > > Can I find values in multiple sheets with vlookup function

$$Excel-Macros$$ How to make query of cells?

Please help me to make query of cells (data) in Excel. (Macros). -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN g

$$Excel-Macros$$ keep one column constant while changes the second

I am trying to run a simple script the calculates the correlation between column B and the column C, then does the same thing for column B and column D, and then column B and column E, etc.I can't figure out how to keep the first column (i.e. column B) constant, while moving reference to the se

RE: $$Excel-Macros$$ Lookup values in different sheets

Hi, IFERROR can be stacked, just like IF can be. Try this formula in C4, then copy down: =IFERROR(VLOOKUP(B4,$E$3:$F$3,2,0),IFERROR(VLOOKUP(B4,$H$3:$I$3,2,0),VLOOKUP(B4,$K$3:$L$3,2,0))) Regards - Dave Date: Tue, 25 Jan 2011 22:57:34 +0500 Subject: $$Excel-Macros$$ Lookup values in differen

$$Excel-Macros$$ Lookup values in different sheets

Hi experts, Can I find values in multiple sheets with vlookup function. sheet is attached. iferror function can be use but it can helpful only with 2 sheet, any guidance? Regards, Aamir Shahzad -- -- Some important

Re: $$Excel-Macros$$ Help Required

Hi Vikram, I am enclosing a file. It would ask for file each time you run the macros. Use this as a template and the save as daily file. Is it clear? Regards Umesh Dev 9019107882 On Tue, Jan 25, 2011 at 7:51 AM, vikram wrote: > Hi Umesh, > > > > I need one more help regarding macro enabled s

Re: $$Excel-Macros$$ User form value in current active row

I've got a macro running right now, so I cannot test the code, but I can describe it! Right-click on your sheet name "tab" and select "View Code". In the VBA editor panel, in the Top-left pull-down, select WorkSheet. The "default" event may be the Worksheet_Change event or the WorkSheetSelection_

$$Excel-Macros$$ Help with Print Preview

Hello I was wondering if there is some way to get the print preview of different work sheets in the preview window. For Example: If my file has 10 different sheets renamed as A,B,C and so on till J If I am Sheet A, when I click on Print Preview, within the preview window, is there an option

$$Excel-Macros$$ Re: Help with Print Preview

Hello Guys Got the solution to my problem described here. Simply right-click on any sheet and select "Select All Sheets" :-D A very very preliminary error on my part. Sorry for the trouble. :-[ Thanks Ashish Pradhan On 25/01/2011 16:37 PM, Ashish Pradhan wrote: Hello I was wondering if t

RE: $$Excel-Macros$$ Macros for paste special-transpose

Hi All, Please unsubscribe my name. this is my official ID Thanks & regards Nandan -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of shivashankar katageri Sent: Tuesday, January 25, 2011 5:37 AM To: excel-macros@googlegroups.

Re: $$Excel-Macros$$ User form value in current active row

Thanks Paul. My column is selectable. If user select/edit in the cell e.g. B3, i want to open the user form and want to write user form value in same row i.e. row3 in column C to H. And also i want to put total CtoH in column B. Thanks in advance. Regds, Manish On Jan 25, 5:54 pm, Paul Schreiner

Re: $$Excel-Macros$$ Copy data validation to create lists

Interesting. I do that quite often Filter data, then copy the resulting data to another sheet. What version of Excel are you using? Paul From: Susan To: MS EXCEL AND VBA MACROS Sent: Mon, January 24, 2011 10:35:32 PM Subject: $$Excel-Macros$$ Copy data val

Re: $$Excel-Macros$$ User form value in current active row

Is column B "selectable"? (When setting protection, it is possible to protect the cell from changes, yet allow the user to select the cell) If it is, then you can use a Selection_Change event and check: If (Target.Column = 2) then within the event, you can open the userform. You'll be able to

Re: $$Excel-Macros$$ Macros for paste special-transpose

copy the data area and use paste special -transpose it u wil get the required r/shiva On Tue, Jan 25, 2011 at 8:42 AM, Manoj b wrote: > Hello All, > > Please can somebody advise me macros for paste special-transpose wherein i > can just copy the data in horizontal format and paste them in vertica

$$Excel-Macros$$ Re: creating forms in excel

It sounds like you are after a simple 'Sales' database type application. You can do this in most MS Office tools. There are advantages and disadvantages to handling this with Excel, and likewise with Access. I would guess that from what you have said, an Access based approach might suit you better