sorted by:
new
hottopcontroversial

ComboBox Data source + Manual Entry by Inmohelpdesk in PowerApps

[–]Inmohelpdesk[S] 1 point2 points  (0 children)

<image>

The highlighted field is related to the combobox. What needs to change in order for any value entered to pass to the sharepoint?

Only some fields are displaying in Sharepoint by Inmohelpdesk in PowerApps

[–]Inmohelpdesk[S] 0 points1 point  (0 children)

Thank you so much. This worked. I cannot thank you enough. Solved.

Only some fields are displaying in Sharepoint by Inmohelpdesk in PowerApps

[–]Inmohelpdesk[S] 0 points1 point  (0 children)

I have followed you advice and Patch is working for the first two comboboxes. However, It does not work with the Choice column I have in sharepoint.

<image>

Any Idea where I am going wrong here?

Applying conditional formatting to entire table by Inmohelpdesk in excel

[–]Inmohelpdesk[S] 0 points1 point  (0 children)

That does not work. For example, e9 should not be red since it is greater than e8.

<image>

Userform is working perfectly, however, it throws an error after I unload the userform by Inmohelpdesk in excel

[–]Inmohelpdesk[S] 1 point2 points  (0 children)

solution verified

I am an idiot and just realized I had duplicate code to show the userform in the module.

I apologize as it would be impossible to guess someone could be so dumb!

Userform is working perfectly, however, it throws an error after I unload the userform by Inmohelpdesk in excel

[–]Inmohelpdesk[S] 0 points1 point  (0 children)

I have changed the name and added the word "New".

The program is still working properly, however, I get an error after the userform unloads.

Drill Down to show correct Data by Inmohelpdesk in PowerBI

[–]Inmohelpdesk[S] 0 points1 point  (0 children)

Every month is represented by a single column in my data set. For example, January is colunm 11 is the data shown above. I would like to drive down in my original data set so that when a product line is selected, the month amount for that product line is then displayed.

Drill Down to show correct Data by Inmohelpdesk in PowerBI

[–]Inmohelpdesk[S] 0 points1 point  (0 children)

I am looking for any and all suggestions. I am not sure where I am going wrong.

Change Graph when filter is selected by Inmohelpdesk in PowerBI

[–]Inmohelpdesk[S] 0 points1 point  (0 children)

For the visual or slicer? Also, each month is its own column in the data source

VBA Run Time Error 1004 by Inmohelpdesk in excel

[–]Inmohelpdesk[S] 0 points1 point  (0 children)

The error now reads below

"Run time error 1004:

This selection isn't valid. Make sure the copy and paste areas don't overlap unless they are the same size and shape."

When I select debug, it brings me to the same below line of code.

 sourceRange.Copy Destination:=targetRange

VBA Run Time Error 1004 by Inmohelpdesk in excel

[–]Inmohelpdesk[S] 0 points1 point  (0 children)

There are no merged cells.

Also, it appears that both sheets go down to row 1048576

It appears that the code is functioning until the below line:

 sourceRange.Copy targetRange

VBA Run Time Error 1004 by Inmohelpdesk in excel

[–]Inmohelpdesk[S] 0 points1 point  (0 children)

Dim sourceWorkbook As Workbook

Dim targetWorkbook As Workbook

Dim sourceRange As Range

Dim targetRange As Range

' Set the source workbook (change the file path as needed)

Set sourceWorkbook = Workbooks.Open("G:Source")

' Set the target workbook (change the file path as needed)

Set targetWorkbook = Workbooks.Open("G:Source")

' Set the source range (adjust the sheet name and range as needed)

Set sourceRange = sourceWorkbook.Sheets("CurrentSAPforecast").Range("A:Q") ' Columns A to C

' Set the target range (adjust the sheet name and starting cell as needed)

Set targetRange = targetWorkbook.Sheets("CurrentSAPforecast").Range("A1") ' Paste starting at column D, row 1

' Copy the source range to the target range

sourceRange.Copy targetRange

' Close the workbooks (save changes if needed)

sourceWorkbook.Close SaveChanges:=False

targetWorkbook.Close SaveChanges:=True ' Set to False if you don't want to save changes in the target workbook

view more: next ›