Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x

Microsoft Applications

43K

Solutions

37K

Contributors

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hello Shums,

If you're still there working on EE, may I ask if you don't mind to help me with a VBA script to automate a Pivot Table.

My boss asked me to but I don't know how.  

Many thanks in advance.
0
Moving data to the cloud? Find out if you’re ready
LVL 3
Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Hello Experts,

I am looking for a VBA code to clear dynamic range of a specific sheet named "Data".

Row 2 has header, from row 3 to last row and last column.

Thanks in Advance.
0
Can we create a button and assign the macro to the button on specific worksheet through the macro.
0
One of my client who uses mapped drive for shared files/folders having issue with saving. It will saves the files, but every instance, there is pre-named file with "Copy of filename.xlsm" .  if he can remove it "copy of" it will be OK, but it is very frustrating for the client to do every time. is anyone had a issue? Thanks
0
I am trying to use vlookup in the excel , But i am getting this error.

 Please help with VBA code - Run-time error '438': Object doesn't support this property or method

ElseIf Ws.Name = "Main" Then
        LRow = Ws.Range("B" & Rows.Count).End(xlUp).Row
        Ws.Activate
        Application.ScreenUpdating = False
        Application.Calculation = xlCalculationManual
        Application.EnableEvents = False
        Ws.Columns(8).EntireColumn.Insert Shift:=xlToLeft
        Ws.Range("H1").Value = "OL"
        Ws.Range("H7").Value = "B/G"
        Ws.Range("H8:H" & LRow).FomulraR1C1 = "=IFERROR(VLOOKUP(R0C4,OL!R3C4:R44546C49,30,FALSE),"""")"   / Getting error on this line//
0
Hi

I'm using the following code which works, I've just been reading about ReDim and was confused why I didn't need. to use it.

At the moment dimension the array with module scope
Dim MyData As Variant

Then the first time I reference the MyData array I use the following code
MyData = TargetWs.Range(TargetWs.Cells(2, 1), TargetWs.Cells(LastRow, LastCol))

Like I said this works, It's just all the examples I see online suggest I should be doing something like this
For cre­at­ing two dimen­sional dynamic array in excel, fol­low the steps below:
Declare the two dimen­sional Array
Resize the array
Store val­ues in array
Retrieve val­ues from array

Should I bedding something different?

Thanks
0
I have a mileage sheet that has a column that the user enters the gallons at time of purchase eg.10.230 gals.How do i sum the total gallons used. eg
10.230
10.230
0
I have a great little WS and two macros that Kevin C. built out for me.   Given I'm going to scale this model out and I want to create a better self doc. within the code, I'd like to use Range Names rather then cell references.  Trying to do so, I cannot figure out how to use the 3 range names instead of the current code with cell references.  

Check it out and Thanks in advance!

B.
Cell-Conversion_v3.xlsm
0
EE Pros,

I am looking for a  macro that will automatically convert a dollar input into a % and if you put in a %, it will convert it into a $ figure.  Both will be displayed.  I have attached a Spreadsheet with a mockup for your review.

Thank you in advance.

B.
Cell-Conversion.xlsx
0
Hi
I have a excel sheet with values on columns. And i have list of formulas that need to updated columns.
I need a vba code that crate a formula column run time and update the values.

I have attached the spread sheet. along with foruma columns need to create and update.

Volumetrics
column -- formula
AN      =IF(ISNUMBER(SEARCH("GIP",J4)),1,0)
AO      =IF(ISNUMBER(SEARCH("TV",J4)),1,0)
AP       =IF(I4="NO",0,1)
AQ  =IF(U4="NO",0,1)

Please help me to resolve this one.. I am very new to excel related task and this is very urgent to do it.

Regards,
final_planning2.xlsm
0
Simplifying Server Workload Migrations
LVL 4
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

The attached spreadsheet visually explains the issue.  Basically want to add a column of data based upon another column of data.
EE.xlsx
0
Hello Experts,

I am trying to insert blank rows between every row of my data; will you help me with vba code to automate this process?

Thanks in advance

Kathryn
0
How to find them?
I know how to fix the problem, I just can't find em. When I filtered and hid a column it happened.
0
Hello Experts,

I am looking for VBA which does exactly as Find & Replace in Excel.
After replacement it should show me how many search words been replaced.

Any help would be appreciated

Thanks in advance
0
Hi ,

I need help on this macro.

When the user select the range (student ID) then click on the Button (Macro), Macro need to update the total,avg, result based on the column values..

Is it possible to  create the drop down to select the range of student ID...




Praveen
0
Hi,

I need to sum some 30+ products like in the image below.
Basically look for the code in the lookup table, take the value, multiply it with the number in the next column. Then take all results and get the sum.
I can do it the long way, but the result is going to be a very long formula that's hard to maintain.

How can I do it with a shorter formula?
Thank you.

2017-09-22-09_39_44-2017.09.xlsx---E.png
0
Normally, you write a negative value with a minus sign with no blank space between, like this:

-48.8

But in my Excel sheet, this is written like this:

- 48.8

How can I change this so it's always written like -48.8 (without the blank space)?
0
Hi all,
We are going to deploy Office 2016 (Currently using Office 2010) through SCCM 2012, what do we have to take into account before update process?
Also how does SCCM uninstalls the old office and installs the new one on the top? how does it differentiates between office32 bit and 64? and then install the right version?
Any articles and steps on how to deploy and configure it will be helpful.
Would installing office 2016 through SCCM would be the best way? or deploying it through Group policy will be better?

Thanks.
0
I have a list of names and email addresses with the following format. How can I separate the names from the emails?

What I have:
Column A
Smith, Sue <smithsss@yahoo.com>

What I want:
Column B                       Column C
Smith, Sue                <smithsss@yahoo.com>
0
Will your db performance match your db growth?
LVL 3
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

I have a pick list of months  (January 2017, February 2017, March 2017)  and a corresponding table by month.  
Depending on what month I choose I want the data for that month to show up under the month that i have chosen.
( I can get it for January but not sure how to add if I pick a different month)
(see attached)

thanks so much
Kelly
1A.xlsx
0
Hi All,
I am in need of your assistance with Excel.

I have an Excel spreadsheet with two worksheets, Shee1 and Sheet2

In Sheet1, I have the following columns
System
Table
Field
Field Mapped
Table Mapped

In Sheet2, I have the following columns
System
Table
Field

The differences between the two sheets is Field Mapped and Table Mapped in Sheet1

How could I populate Sheet 1.Table Mapped with text Y where
Sheet1.Table
match
Sheet2.Table  

Could this be done with a formula please? I am afraid I do not have access to VBA or to run macros due company policy.

This question is very similar to the question below
https://www.experts-exchange.com/questions/29057789/Columns-matches-from-two-seperate-worksheets.html

Many Thanks.
0
Hi ,
Please help me to create excel marco for attached excel sheet.
test.xlsx
0
Count the number each item appears in a selected column and produce those values in a new tab.

Column A of New Tab = Original Value (text or number)
Column B of New Tab = Number of Times Value Appeared

Assistance is greatly appreciated.  A sheet might contain as many as 15,000 rows.
0
Not sure the best way to get what I need.

I would like total of hours for dates in the past in column D

I would like total of hours for dates in the future (including current day) in column E

See attachment
Planning.xlsx
0
I would like to have the following formula show the totals if the date is in the past

=SUM(APJ6:APU6)     /    total for dates in the past

Also show the total it the date is in the future.

=SUM(APJ6:APU6)   /   total for current day and future dates
0

Microsoft Applications

43K

Solutions

37K

Contributors

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.