Search results

My above posted thread is resolved.

1. "Yes, sure going a head will see to the points you raised and will keep posted." - It means will inform in future if already its resolved. 2. If Your clearing was: 'Hi, Please find the attached final file.' - I have provided you final file. 3. I had ALSO asked 'Did You test it?' No answer! -...

Thanks Deepak, after your post I review the code again to explain in detail and think this could work let me try. .Cells(LR, i + [B1].Column).Value = Sheets("Form").Range(cls(i)).Value and .Cells(LR2, j + [EO1].Column).Value = Sheets("Form").Range(cls2(j)).Value Will inform if its not...

Yes, sure going a head will see to the points you raised and will keep posted.

That was just for approval, Now to improve it more trying to lock the cell. your response was not to the point even after clearing your queries there were still confusions. This thread is completely different to the thread you mentioned above.

Hello, I was trying to lock range of cell say A:HR if value of HR for that particular row is "Approved". There are two sheets 1. View_Form - to view specific selected values and click macro button Approve. 2. Tracker - Data base where Cell HR updates while clicking Approval button of sheet 1...

Thanks for your help @vletm I used the below code its working just as I need. Another forum helped me out very quickly. Sub Approval() Dim found As Range 'define variables Dim SelectedFileID As String SelectedFileID = Sheets("View_Form").Range("SelFileID").Value 'get the currently selected...

Hi, Please find the attached final file.

Hi Vletm, I have attached the final file :) thank you so much in advance. Also, have one suggestion can we make entire sheet property as locked will get unlocked if HR cell value is "Approved". so that the sheet will be password protected but Unapproved rows can still be edited.

Hello, Can anyone help me with the above query please?

Hi Vletm, Thanks for your response, Yes as of now there is no password but what i am looking for is when we click Approve the respective row in Sheet "Tracker" should get locked with password say "1234", and at same time the HR cell should show value as "Approved" which is viewed and approved in...

Dear Coders, Please help me out I am working on the attached file, and what exactly I was looking for is a vba code to set approval of data entered in the sheet "Tracker". From the Sheet "Form (VIEW)" we could select data recorded in another sheet as "Tracker" by selecting drop down cell...

Hello, Can some one help me with the below code, what I am looking for is, from sheet "Form" certain values of cells mentioned in 2 sets of Array. 1st set of Array should get copied to sheet "Tracker" C3 onward and second set of array from next cell after the 1set of array ends say EF3 onwards...

Thanks but, was not of much help. I would look out in some other forums.

Thanks, but I was looking for something which could go in module1 so that I could tweak and blend it with other existing code. Is there any other way to put it in module1

Hello, File is attached and the code is in module.

Sorry to respond late, I tried refreshing the pivote table but its not working.

May be I am doing something wrong, could you please attach the file if possible. Because I am still not getting any results for filter. All the pivot filters are still in default condition as ALL.

Hello @Chihiro did you get a chance to look into it.

No its not running. Attached the file the code is in Module 1. :(

@Marc L, Thanks just as needed :)

@Marc L No I am getting Compile error: Method or data member not found. Sub CopyHeader() Dim S As String Select Case Range("A2").Value Case "FC": S = "A6:AB6" Case "FP": S = "A2:AA2" End Select If S > "" Then ThisWorkbook.Range("Template!" & S).Copy Cells(1) End Sub

Postcode #4 used the following code: Sub CopyHeader() Dim S As String Worksheets("Text").Activate Select Case Range("A2").Value Case "FC": S = "A6:AB6" Case "FP": S = "A2:AA2" End Select If S > "" Then Range("Template!" & S).Copy Cells(1) End Sub

Hello All, I got one question for the above code. Actually I am running macro code keeping it open to another excel file. So, the above header is not getting copied from the Macro source file template sheet to the working active sheet. That is the template sheet is in Macro file and should get...

Hello Chihiro, Apologise for the confusion, I have uploaded a new spread sheet. Basically what I am looking for is, in the attached file there are two sheets. 1. Report 2. Pivot I am looking for a macro which could display each five pivot filter i.e. A1:B5 if it has only a single value else...