$$Excel-Macros$$ need help with looping a find - cut - paste macro Excel 2013

2015-01-08 Thread JenIT
I have a macro I am working on. I have found a way do the find, cut and paste, but it does not loop, It stops after it does the find, cut and paste one time. When there are blanks in K there will be data data sitting in L that needs to be moved to P. I KLM NOP123 main streetSEDALIAMO65

$$Excel-Macros$$ Re: If then elseif on same sheet not looping

2014-11-10 Thread JenIT
> > Paul thank you! > Not only did the code do the trick but you were extremely helpful in explaining the logic behind the code. I appreciate your 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 official Facebook page of this fo

$$Excel-Macros$$ If then elseif on same sheet not looping

2014-11-10 Thread JenIT
Hello, I'm sure the answer to this is out there, but I am not searching correctly to find it. I have code to past the result of an if/then/elseif statement from column B into column A. It works for line one and I am drawing a mind blank and I can't get it to run through the whole sheet (variab

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

Re: $$Excel-Macros$$ convert time formatted as text to military time and join with date field

2012-11-29 Thread JenIT
XT(C3,"hh:mm") > > > > -- > *Regards,* > * > * > *Excel Beginner* > * > * > On Thu, Nov 29, 2012 at 11:20 PM, JenIT > > > wrote: > >> My data is opened from a downloaded file. I do not have an import >> functions as data exports as exce

$$Excel-Macros$$ convert time formatted as text to military time and join with date field

2012-11-29 Thread JenIT
My data is opened from a downloaded file. I do not have an import functions as data exports as excel and I believe my cells are formatted as Text since I cannot seem to make any formatting change the data.I need to to change from it's current format to military time and then also combine t

$$Excel-Macros$$ Schedule Multiple Macros to Auto Run

2011-10-18 Thread JenIT
I have one macr workbook that has several macros. I didn't know if there is a way to have more than one Macro be scheduled to run at a certain when the Macro workbook is opened. I currently have Task Scheduler running to open the workbook and then it runs my macro at a certain time. Here is the