Hello! Hopefully you can help me to solve my problem!
I have excel workbook with multiple sheets. And the sheet orientation are both - vertical and horizontal. I have faced the problem, changing the header information for all sheets, automatically all sheets change the orientation to Vertical...
I have a cell in a table that seems to be giving me trouble when I try to import into Power BI from an excel sheet.
Here is the issue:
Cell E2 (blue A) : Has three entries that appear to be on individual lines, but in the same cell. When I try to take this to Power BI, it only...
I have an excel table that I'm building for scheduling / planning purposes. I want to be able to utilize the headers as date values that I can reference for summing assigned hours that are in a column whose header date is greater than the last day of the previous week. The formula I'm...
I'm quite new with macros in excel so I'm relying on your expertise.
Let's say I have a table with headers and I'm using the count formula in a macro and this is the code:
' Test Macro
ActiveCell.FormulaR1C1 = "=COUNT(Sheet1!C)"
The header of the...
I'm working on a sheet that spans two pages, and I'm trying to format the page setup in VBA (as the culmination of a number of other operations the macro is executing). Since the result is on only two pages, it doesn't matter to me whether it's odd/even pages or different first page.
In my page...
Just wondering if this is possible, I have a lot of colored filled cells in my document that I need to print black and white. I only want my logo that is currently in the header to print in color. Is there a workaround for this? I know I could do a watermark on the finished pdf, but I would...
Hello, using vba i am looking for a way to find a header/multiple headers, the first header is called "Test A" and starts on row A51 and has a range where values are.
The next header after that is "Test A-1" and same thing has a range of values, but that one is in column A but the row can be...
Okay, I found this bit of code from a post back in 2010, and I am hoping that somebody can please help me figure out what kind of variable "hb" should be, and what it should be pointing to because the original person that posted this code never included them at all. I know this code was intended...
I have around 250 sheets in a workbook all with a unique sheet name. I have 250 unique pictures (custom border templates) that correspond to the sheet name which I would like to insert into the header. How could I do this without manually going into each sheet inserting the picture and...
I am completely, absolutely 100% new at Power BI. This is my first official day, so please bear with me :)
I currently have the following Dashboard:
Now, if I insert an image I can get it it to fill all of the screen except for below the dotted line (my red arrow is pointing at...
Apologies ahead of time for the ugly code. I am a complete novice at this and have used inputs for forums like yourself to kludge together something that appears to work, except that I can't get it to run successfully when I push play. I've seen a lot of posts about only working when...
Hello friends and community,
I am very new to vba and trying to figure out how to do below.
I need to copy a pivot table's data from one workbook to another
Copy from the highlighted header (Week number)
Paste to the highlighted header in another sheet
Difficulty & Concern:
1. the header...
Hello Brave Excel Lovers and Helpers
I have an Excel File in which there are three Nos. Sheets and a Userform (File is attached)
I can only generate report for single selected row from Userform Listbox1 (see MyReport) But this is not what I need. I then...
I'm currently changing the logos in bulk for 1000s of documents and know there to be an easier way to do this.
I have some template documents which contain the right header and footer placements for each of the images, but I, so far, have not been able to translate this into bulk...
We keep a server list in Excel ready for any dinosaurs still lurking who want to read it.
I'd like to show at the top of the spreadsheet (C2, D2, E2)
last modified cell (highlighted would be a nice touch)
I am looking for some VBA code to help me with the problems, it would be great if one can help.
I have 2 workbooks, and there are multiple worksheets in each of these workbooks. In workbook2(sheetname1) I would like to find the column in workbook1(sheetname2) that has the corresponding...
So I need to get some names and make userform inputs
so heres what i need,
I have 5 Cells with headers and 5 cells which need readings
I have userform1
I want to take userform1 and Place the headers from Cells A10,C10,E10,G10,I10 to header boxes
Below the header boxes I have Input...
Just wondering if there's a more clean and condensed solution to this macro I'm working on. I'm trying to map data from a client's payroll file onto our template in order to upload it to our system for record keeping. I need to copy the data (all rows in the column directly below...
I have some vba code that copies rows from a table to another table on another sheet.
The headers for columns D, F and G on the destination table keep being replaced with column1, column 2 and column 3, instead of being left the as they are.
I can't see where it is doing it in the code. Could...