$$Excel-Macros$$ Write a macro 2 get the user input and based on that filter the rows and put into the another sheet

2013-12-17 Thread Komali Pendurthy
Question: I have created one excel sheet. it contains one command button. By clicking on that button it should show the user form for taking the input from the user. when we clicked submit on the user form it should hide and get the input into variables. Based on the given input it should filt

RE: $$Excel-Macros$$ folder check

2013-12-17 Thread Ravinder
PFA, first select folder from where you want to get result, after getting result you can open folder by clicking on link. From: ANAND S [mailto:anand...@gmail.com] Sent: Tuesday, December 17, 2013 4:50 PM To: excel-macros@googlegroups.com; ravinderexcelgr...@gmail.com Subject: Re: $$Excel-Macr

Re: $$Excel-Macros$$ Password Assistance

2013-12-17 Thread Dhartikumar Sahu
share the excel file On Wed, Dec 18, 2013 at 11:20 AM, Jocky Beta wrote: > Hi, > > Can you share the Excel sheet? > > Regards > > > On Wed, Dec 18, 2013 at 3:06 AM, Adam Subelka wrote: > >> I have a Excel 2010 file that is VBA Password protected. The person who >> protected the file is no long

Re: $$Excel-Macros$$ Password Assistance

2013-12-17 Thread Jocky Beta
Hi, Can you share the Excel sheet? Regards On Wed, Dec 18, 2013 at 3:06 AM, Adam Subelka wrote: > I have a Excel 2010 file that is VBA Password protected. The person who > protected the file is no longer with the company and I cannot find anyone > who can unlock the file. > > I have a macro t

RE: $$Excel-Macros$$ Re: Need help

2013-12-17 Thread Ravinder
Please forum members don’t pay attention on this totally fraud……….mail…. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Basole Sent: Tuesday, December 17, 2013 7:15 PM To: excel-macros@googlegroups.com Cc: philip...@yahoo.com Subject: $$Excel-Macros$$ Re

Re: $$Excel-Macros$$ vlookup query

2013-12-17 Thread rajeyssh
I want to put vlookup in 7th to 9th row in column A to J from sheet 1. On Tuesday, December 17, 2013 5:42:18 PM UTC+5:30, ravinder negi wrote: > > What is the lookup value > > > > *From:* excel-...@googlegroups.com [mailto: > excel-...@googlegroups.com ] *On Behalf Of *Rajesh Agarwal > *Sent:*

$$Excel-Macros$$ Password Assistance

2013-12-17 Thread Adam Subelka
I have a Excel 2010 file that is VBA Password protected. The person who protected the file is no longer with the company and I cannot find anyone who can unlock the file. I have a macro that will unlock each sheet, but I can't run the macro with the VBA protection. Is there a way to get ar

$$Excel-Macros$$ Combine 2 rows - if col A is the same - append to end

2013-12-17 Thread JenIT
I have a sheet that can be varied columns wide. I need to search down and if the value in Row 2 col A is the same as the Row 1 col A, then take the data from Row 2 and append it to the end of the data already in Row 1. Then continue searching down the remainder of the rows for the same and mo

$$Excel-Macros$$ Re: Find, move & delete

2013-12-17 Thread Bill Q
Besole, No apology needed. I think I am guilty of not being specific enough. See attached spreadsheet. - "Main" tab contains the raw data. - "Results needed" tab contains what I am looking for from the macro. Thanks. On Tuesday, December 17, 2013 12:11:41 PM UTC-5, Basole wrote: > sor

$$Excel-Macros$$ Re: Find, move & delete

2013-12-17 Thread Basole
sorry Bill, try now this: Sub CLEARNUMBERS001() s = Array("+", "-", ".5", "-.5", "0", "1", "2", "3", "4", "5", "6", "7", "8", "9") For Each r In Selection v = r.Value ActiveCell(1, 2) = v For i = 0 To 13 v = Replace(v, s(i), " ") Next r.Value = v Next End Sub Basole Em segunda-feira, 16 de

$$Excel-Macros$$ Re: Need help

2013-12-17 Thread Basole
Hello Philip, I think this is not an appropriate environment to request this kind of help! regards, Em terça-feira, 17 de dezembro de 2013 11h37min16s UTC-2, Philip escreveu: > > Hope you get this on time, I made a trip to Ireland and my Bag was stolen > from me with my passport, cash and cr

$$Excel-Macros$$ Need help

2013-12-17 Thread Philip Mann
Hope you get this on time, I made a trip to Ireland and my Bag was stolen from me with my passport, cash and credit cards in it. Unfortunately, I made contact with my bank but they are not providing a fast solution. I will be glad if you can lend me the sum of 1,500 usd or any amount you can afford

RE: $$Excel-Macros$$ vlookup query

2013-12-17 Thread Ravinder
What is the lookup value From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajesh Agarwal Sent: Tuesday, December 17, 2013 5:34 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ vlookup query -- Rajesh Kumar Agarwal 9811063001 -- Are

Re: $$Excel-Macros$$ folder check

2013-12-17 Thread ANAND S
Hi Ravinder, I have multiple folders with different folder names.(main folder), each main folder having multiple sub folders with different names and each sub folder having multiple workbooks. Workbooks are having different worksheet names. These reports are Automated. I need to find the workshee

RE: $$Excel-Macros$$ folder check

2013-12-17 Thread Ravinder
Pls clear your query. With example if possible From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Anand S Sent: Tuesday, December 17, 2013 4:10 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ folder check Hi I have multiple folders

Re: $$Excel-Macros$$ sum numbers only

2013-12-17 Thread priti verma
I think it is not possible with sumifs because Sumifs,sumif...etc function does,t support array. On Mon, Dec 16, 2013 at 12:17 PM, Satiqjaffar ali wrote: > Hello Priti, > > Thanks for effort, and can you please explain the same with SUMIFS > function.? > > > On 16 December 2013 21:01, priti ver

$$Excel-Macros$$ folder check

2013-12-17 Thread Anand S
Hi I have multiple folders in path and each folder having multiple excel files with different names. I need to check that all blank cells in work sheets with excel file name. Thanks in adavance Anand -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2

$$Excel-Macros$$ Chart Help

2013-12-17 Thread prabhakar_kavi
Hi Team, I need your help to modify the attached chart in more attractive way. Please help me to insert "Sewing Attrition % within the Blue box. and simlar to other box also. Pls help. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join o

$$Excel-Macros$$ HOW DO I SAVE TABLE DESIGN DATA

2013-12-17 Thread sridher sharma
how do I save a table? I have taken my data, created a table and then tried to 'save as' but when I reopen it, it is back in the original worksheet format. What am I missing? Thanks in Advances Sridher Sharma -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2

RE: $$Excel-Macros$$ Need a macro to open & copy data from a given path

2013-12-17 Thread Ravinder
PFA, first select paths. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kartik Dale Sent: Tuesday, December 17, 2013 1:54 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need a macro to open & copy data from a given path Hello Experts,

$$Excel-Macros$$ Need a macro to open & copy data from a given path

2013-12-17 Thread Kartik Dale
Hello Experts, I need a macro to open a particular folder from excel and should copy the file name & sheet name & A1 value from each sheet. PFA Thanks Kartik -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of thi