Search results

Hey Luke, I fixed it...thanks a millions for your support... My final code... Sub Make_Individualreport() Dim pdfName As String Dim spath As String Dim stlist As Range 'Define where the list of names are Set stlist = Worksheets("Prj Managers").Range("A1:A30") 'Now we loop through the...

Hey Luke, Thank you very much for the reply. Only issue here is ... Students name is in Worksheets("Sheet2").Range("A1:A30") where as report template which needs to be printed is in Sheet1 Print_Area. Names from A1 to A30 should get copied in Worksheets("Sheet1").Range("C3"). Can you please...

I have created a report for a report card. Student's name is stored in sheet2 and report is present in sheet 1. cell C3 contains Students name. I have 30 students and what i need is C3 should change automatically by using list f 30 students in sheet 2 and generate 30 different reports and save...

hey!! Finally ended up with this code Sub ClearOptionButtonsForms() Sheets("B.").Select ActiveSheet.OptionButtons.Value = xlOff End Sub

Narayan, Thanks for your patience... I have 3 radio button in a sheet all are linked to Cell A3. First time i am selecting one radio button save my sheet. Next time when i reopen i need to set all my radio button to blank at a click. For this i am using the above said code. How do i do that as...

if i add the radio button by Form Controls and link it to a cell it will not work,if i add radio buttons by ActiveX control it works but i cant link it a cell. Dee

Dear Experts, I have a macro which reset all the radio button to blank at a click but the same will not work when the radio button are linked to a cell. Here is my codes... Private Sub Worksheet_Activate() For x = 1 To Sheets("B.").OLEObjects.Count Sheets("B.").OLEObjects(x).Object.Value =...

Wow!! that's great thank you very much Hui...

Dear experts, i am trying add a text called "NULL" in the last cell next to the list in a row. EX: if list starts in A1 and ends in C1 then the word "NULL" should come in D1. Below is the code i wrote somehow it is neither working not showing any errors. Can any one of you help me on this...

Hi Narayan, Thanks for your time. I tried with this codes but was no success. Dee

Hi Luke, Thank you very much for the solutions. I have a issue here... The above code is removing the filter from report filter and is showing all the values in the pivot table. What i am looking at is, i am changing the filters of pivot table1 and refreshing the pivot table 1. when i run the...

Hi, Is there a way to update the filter to other pivot tables same as that of first pivot table using macros? I have 4 pivot tables in a sheet and i am applying filter to first report filter and i want same thing should be updated to all pivot tables via macros. can Macro experts help me on...

I need to add Grand total to pivot chart. Grand total column is appearing in pivot table but it is not considered in the pivot chart. Can you guys help me in showing GRAND Total in the Pivot chart? Thanking you in advance, Dee

Hi guys, I wrote the below stuff to do the same but the problem here is it copying all the data to first column of the "Project list" sheet instead of corresponding columns. Can any one of help me on this pls ? Private Sub copyWithSelectedHeaders() Dim row As Long Dim column As Long...

HI, I have list of heading in Sheet "Headers", if these headers list matches with column headings of "Productivity_Project_Record" then it should copy the entire column from "Productivity_Project_Record" to corresponding columns in "Project List". Hope i am clear Thank you, Dee

Dear All, i am trying to copy columns form sheet called "Productivity_Project_Record" to "Project List" only those columns whose heading are there in sheet "Headers" ie., from A1 to A55. Here is my code i am struggling with... can any one of you pls help me on this Private Sub...

hi Hui, File has been sent you Thank you, Dee

Hi, I am trying to convert 2003 Excel file to 2007 macro enabled version but i am getting error like... "Excel found unreadable content...Do you want to recover the contents of this workbook?" If i choose YES It will open a repaired version of the file by removing the unreadable contents.If i...

Hi Hui, Thanks for the reply... Can't consider the subtotal of data toolbar as i am adding the rows and many formulas via macros...

Hi all, i have big list of 100 rows and 20 columns data for which i need to add sub total for each change in levels. For Ex: Level 1 is broad category which have many Level 2's and Level 5's Each level 2 is again have sub categories like 3's and 4's. under each Level 2 we may or may not get...

Hi, These links may help you... http://www.avdf.com/apr98/art_ot003.html http://www.cpearson.com/excel/optimize.htm Happy coding.... :)

hey guys... even though i got this...i have one more requirement. In the above codes i can look for only one column header and copy it but i need to check more 3-4 columns and copy it... Can any one of help me on this... Thanks, Dee

Hey! Got it guys... Thanks Luke, as i am not aware of query in excel i tried this... If possible can you explain how it can be done in this case? Sub copycolumns() Dim rng As Range Set rng = Sheets("Raw Data").Range("A1:IV1").Find("EMP ID", LookIn:=xlValues) rng.Offset(1...

Hey All, I am trying to copy few columns from one sheet to another or from one file to another using excel macros. It should pick the columns based on the column headings (EX: Emp Id, Location,Department etc.,). Can any of the macro experts help me with macros. Thanking you in advance, Dee

Hi Jitender, Or else you can also you conditional formating to highlight the duplicates. Home --> Conditional Formatting --> Highlight Cell values --> Duplicate Values.