$$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

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 manoj.bi...@gmail.com wrote: Hello All, Please can somebody advise me macros for paste special-transpose wherein i can just copy the data in horizontal format and

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$$ 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 sunni...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Mon, January 24, 2011

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

$$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

$$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

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

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 vikramahuj...@gmail.com wrote: Hi Umesh, I need one more help

$$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

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

$$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

$$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

$$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 aamirshahza...@gmail.com wrote: Hi experts, Can I find values in multiple sheets

$$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

$$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 --

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() Dim Temp