Hi Friends,
Need your help in highlighting my error for the below code.
'Define the variables in the sheet of the macros
Workbooks(wbmacro).Activate
Sheets(Acc).Visible = True
Sheets(Acc).Select
''Look in what row are the titles
Dim MRow As Integer: MRow = Cells.Find("MMS ID").Row...
thanks Vltem..but I guess I was not able to convey the right message to you.
let me try again :
I have dates with dates having time intervals in column A , and planned dates in column G.
lets say when between 12/30/2018 the planned dates has only 11/12/2018 hence we will count it as 1
again...
Hello Friends,
I need your help in getting the no of occurrences for a time interval from a range of dates.
for example in column A we have time intervals for 15 days between the dates and from column G we have planned dates , now in column B we need to count the number of occurrences that...
Hello Friends,
Need your help here ..I need to find a letter "O" from the range column T and convert the existing number in column L to negative.
For Example:
Row no 10 having 71.58 should be changed to -71.58
similarly Row no 26 should be also changed to -71.58.
Appreciate your help on the...
Thanks Vletm..for highlighting the error.
I could manage to crack the requirement for most of the scenarios but could not able to get the formula ....=IF(ISNUMBER(FIND("I",T2)),"Internal","External") in colunm CG.
The reason for the getting it to run through vba is one of the requirement where...
Hello Friends,
Need help on running the below formula on columns CE and CF and CG using Vba.
The range is dynamic in nature and not constrained to constant.
Appreciate your help on the same.
CE =VLOOKUP(AK2,'Country – Service HUB'!A:C,3,0)
CF =VLOOKUP(AK2,'Country – Service HUB'!A:B,2,0)
CG...
Hello Friends,
I need help in getting an output in location column as "Internal" if column A starts with letter "I" any other text or number should be " External"
Appreciate your help here.
Hi Vltem,
A small change , I wanted to run this on the sheet name called "KPI".
so can we change the
With ActiveSheet
to
With Sheets("KPI").Select
----------------------------------------------------------------------------
Sub Do_It()
Application.ScreenUpdating = False
With...
Hello Friends,
I need some help regarding find duplicates from column F and rename column CF as "Yes" and "No" if there are any duplicate records in F.
Appreciate your help here.
Attached sheet for your reference.
Thanks Vletm...one minor change .The below columns headers will be not be existing in base sheet while copying the extract from other file.
can we insert a header as " country" and "region" along with while running the code.
Thank you.
Thanks AlanSidman,
Need your help in v lookup for the last two columns of the data using vba .
The last two new columns should be name as country and region.
Hi Team,
I have a data where in the range differs from one period to another.
Need your help in vlookup for the last two columns of the data using vba .
The last two new columns should be name as country and region.
Appreciate your help here
Thanks Vletm for the support.
the ask for me was to create only the "Total Value of Average of C Value and count of Ckey " in the pie.
But the challenge here is everytime a new KPI is added , we have to change range the new KPI accordingly.
I have added KPI K in the base and while refreshing...
Hello All,
I have few data points where in I need to insert a separate column for average of two variables.The average column is manually inserted.
I have a challenge in pie chart where in I have to show:
Each KPI Week wise Average ( Depends upon on number of KPI's in Header)
All KPI together...
Hello Friends,
I need you assistance here , I have to fill in the header of each of the worksheets for the below code with Amber .
This code is for copying data from one folder(containing multiple workbooks) to a single work book in to different worksheets .
Now when the data is copied and...
Hi Vletm
1) Is this 'once-in-the-lifetime' or daily action? Daily action
2) Is range always same with each file? no, the range is not constant across all workbooks
3) Have You tested to do that copy manually?
... about ~five steps, if five files -->>> Maximum the files can be 7 and...
Hi Vletm,
Thanks for your reply,
1.this is a lifetime activity which is my bread and butter.
2.yes there is always a single worksheet in all 5 workbooks but the range is different.
3.this data is picked up by the client from the C:\temp where we run a dashboard on it by running some formulas...
Hello All,
I have to copy data from 6+ workbooks and paste it into a master workbook in different worksheets .
All the workbooks are located in a folder on my desktop: C:\Users\xbv\Desktop\TestFolder
Request your help here please.
output :