I have a code that copies data from column C or E if there's no data on column C from all sheets on the workbook except the master sheet
But this code is not completely mine, I asked a colleague help to make it for me
What I know is that it also depends on column G
Can someone please explain to...
Hello Power Users!
I want to create a macro to export a specific range, in a specific workbook to a .txt file. Then title the .txt file with a name from a cell within the workbook.
Data I want exported to notepad as text:
1.Range: B2:N34 ---> Sometimes this range will be larger, so I would...
Hi all,
I have this file:
How do I make a conditional formatting formula (or whatever it takes) so if the COLOR (not the text!), but the color in column C is red, then the color for the respective cell ("hello" and "this" in cell A1 and A3) will also turn red?
Hope my question makes sense...
Hi all,
I have this macro:
Once I press the macro "Save file to folder", I get the error above, and debugging it leads me to this:
I want to save my file as a PDF file in the path above. Any idea why it does not work and how I can fix it?
Kind regards,
Jyggalag
Hi all,
I am having a huge issue at the moment with some macros i created (through record macro).
Basically, I have this excel sheet:
I tried to record some macro's, where once I press unfreeze, they post this formula:
=IF(ISBLANK(B9),"",TODAY()) for the left one...
code
coding
copy paste
copy paste as values
excel
formula
help
iferror
index
indexmatch
jyggalag
macro
match
olzenmedz
record macro
today function
today()
vba
vlookup
yonasreppenk
Hi experts!
I am looking for your help with a project of mine.
This is what the end state of my idea is.
When I place a number that is associated with a folder inside the orange box it will rename that folder "Folder" without a number. When there is nothing or a 0 inside the orange box all...
Hi all,
I have this data sheet:
I have turned it into percentages and I assume that the top value (0.36% & -1.52%) are the sums of my columns (I am very new to Pivot, sorry).
But I have #DIV/0! errors! :(
Is there a way in which I can implement an IFERROR formula for my entire pivot table...
Hi all,
I currently have the following setup:
I have marked everything that I want to be exported into a PDF, which works when I manually save the file as a PDF.
However, I do also have a macro ("Save file to folder") as seen above, which saves the file (albeit as an Excel file) to my...
Hi all,
I currently have a bunch of files that are 99% similar, except they have some different data in their columns. The first two rows will always look like this:
Unfortunately, the first row messes with the power query, so it returns this:
If I remove the first row, my file works such...
code
conditional formatting
easy
excel
fast
formula
help
indexmatch
jyggalag
macro
pivot table 365
power cable
power query from folder
svorkieboy
vba
vlookup
Hi all,
I am currently using this formula:
With its neighbor formula in column C going like this:
My question is whether it would be possible to somehow freeze my data in cell B3, C3 etc. going forward? So once the formula detects that a data entry has been in the cell 2 rows below it, it...
Hello, I am trying to find a way to use VBA to clear all cells below row 1 on an excel worksheet.
Row A has headers I want to keep but would like vba code that I can put into a button to clear all cells under row 1, so clear rows 2,3,4, etc.. Also the sheet is called "User Info". So would like...
Good Afternoon,
This seems to be a pretty common request, and I have tried other codes in other threads, but none of them are exactly what I am looking for.
Heres the Goal:
Create a new folder in a particular part of my server (This changes based on the information they put into the...
Hi all!
I have this formula:
But for some reason, my formula does not work? I want my formula to return "NOT BLANK AND NOT 1" if the cell contains a value that is not = 1 and not a blank cell. If the cell contains the value 1 or is blank, i want my formula to return a blank cell.
Can...
Hi All,
I am currently facing an issue in with my pivot table that I have been absolutely unable to fix and it does not seem like the Power Pivot forum is very active compared to this one.
In addition, mine is more related to Pivot Tables than Power BI, Query or anything like that, so I may...
code
data source
excel
formula
formulas
help
iferror
indexmatch
jyggalag
lookup
pivot table
pivottable
power
power bi
query
source
svaerke
vba
vlookup
xlookup
yonasreppenk
Dear all,
I have currently made a pivot table, which I am linking to some Power Query data.
The data in the power query comes from a folder where I import files from a website, so these files will ALWAYS have the same file name, sheet name and column names. However, the data under their...
Hi all,
I am considering to use power query to get data for my pivot table. However, I am EXTREMELY new to both pivot tables and power query.
I want to import data into this pivot table (not using power query below):
I have the source data saved here:
So questionnaire data file 1 is week...
Hi all,
I currently have a sheet that looks like this:
(Please note that I have divided my excel file into two windows, so you can see both sheets at the same time).
I have created a pivot table (very new to this!) in Sheet2 where I can store the data. I expect, from now on, to download my...
Hi all!
I currently have this setup in Excel:
And the code is this:
Option Explicit
Private Const FilePath As String = "\\COMPANY.MSAD.COMPANY.NET\userdata\t543932\home\Documents\TESTfolder\"
Sub send_email_complete()
Dim OutApp As Object
Dim OutMail As Object
Dim i As Long
Dim...
Hi all,
I currently have the following setup:
The macro will send out an email to the 1st contact and BCC with this VBA code:
Option Explicit
Private Const FilePath As String = "\\COMPANY.MSAD.COMPANY.NET\userdata\t865934\home\Documents\TESTfolder\"
Sub send_email_complete()
Dim OutApp As...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.