Search results

This what I have so far Sub action() Application.ActiveWorkbook.Path ActiveSheet.Name = ActiveSheet.Range("A1").Value Worksheets(Worksheets.Count).Move before:=Worksheets(1) End Sub Couple problems. I'm getting a compile error on .Path and every time I run it.... And once the last tab...

Thanks for the code for line 2. I am just a novice on vba, This is what I would like to succeed using a macro. 1.) rename a tab on several worksheets example tab6 to tab1 2.) move tab6 to tab1 position 3.) where do I enter the directory within the vba code so it can run it from temp_master...

Hi All, Looking to move last worksheet to the front of the book on multiple workbooks and save them all as a PDF's Any help would be greatly appreciated Regards, Dennis

T hanks I end it up using =IF(AND(D3>0,D3<10),"*",IF(OR(C3="",D3=""),"-",C3/D3)) it works just fine. Thanks Dennis

Hi All, my formula is almost there, it needs a litle tweaking. If no data in a cell, I would like "-" if less than 10 "*" =IF(D3<10,"*",IF(D3=" ","-",C3/D3)) Output should be C D output 16 34 47.1 blank blank - 1 6 * Thanks Dennis

Thanks, You are the "best"

Thanks for your response, I try running it but stops short here. Maybe I'm missing something. fs.CopyFile sFileSource, sFileTarget, True Regards Dennis

Hello All, I have 6 excel workbooks(templates) and 123 folders, some folders get all 6 workbooks but other get less, is there a way(script) that I could run and insert them as requested. Example: temp1,tem2,temp3 &#62; folder 1 temp2 &#62; folder 2 temp1, temp4, temp6 &#62; folder 3...

Thanks for your effort, The only way I could get this done was using a MS Access update query, I updated table A with information from table "B" where applicable. I'm trying to streamline the process with a single sql statement but sometimes its not possible for many reasons. Thank you...

Here you go I have two tables that I need to merge, however there is a catch, on table "B" , not all depts have data in grades from 3-8, if data is missing I would like to have an empthy row with the grade and dept. Please see below Table "A" has a field column named grade: SELECT A.grade...

Please let me know Dennis

Here you go, I inherited this macro, so where would line 7 be? Public LastRow As Integer Sub fillup() ' ' Automatically populate values in a template ' Dim path As String path = "P:DPD&ADepartment_Work_ProductAccountabilityPerformance Policy2012-2013 policyReportsElementary...

Hi All, I have an excel file template that is being populated with a vba macro, it runs fine up to a point then suddendly stops, if I removed the data row where the macro stopped, once resetted, it will start running again until it finds a reason to stop again, I'm wondering if it has...

Thank you!!!!,I will give it a try

link:http://sdrv.ms/PUP7rT Is there a way to merge these two workbooks into one so the end product will look like this. (21 rows per each "un" with a total of 11,151 rows) Un yr num 2130 2010 3 2130 2010 4 2130 2010 5 2130 2010 6 2130 2010 7 2130 2010 8 2130 2010 38 2130 2011 3...

Thanks!!!!

Hi all, I have this code that works fine except I'm noticing now that where there no data is present the output should be blank, but I'm getting a '0%' value instead. I'm attaching a sample dataset for you to review it Regards,, Dennis http://sdrv.ms/PsMq0W

Thanks for your quick reply, I think, I'm not communicating properly sorry about that, what I would like to see in the column under Index_id 35, B40 is the word "Scantron" or "NWEA where the case maybe. And it will happen based on the selection from the dropdown. The cell B40 description is...

here is an example, There are two categories, if you select the dropdown by school name, the "L" column needs to be populated under Index_id 35 B40, however because there are missing cells and it will not do so. http://sdrv.ms/PsMq0W

Sorry for the confusion, I'm using the following code, However there are two types of category testA, and testB...

Ok, My cell reads as follows =(a1:a4) however when A1 data is missing I get a "0" zero value. I would like to get the category name =test

Hi All, I have a category name call test(sample) in a range of cells, sometimes a value maybe missing how do I adjust my statement so if one cell is missing still get the category name sample: a1=test a2=test a3= a4=test output=test thanks Dennis

Thank you !!! you are a "genius"

Quick Q? when I do the average on this column, I get the #N/A in the result, how do I adusted so it output is correct 51.8% #N/A 37.0% 51.2% 53.5% 34.4% ------- #N/A Thanks Dennis

I've got it!!!