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...
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 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.
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 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
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.
@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...