Forum

Hi Aaron! My recommendation would be to write a macro that will copy the data from your e-mail and paste it into your spreadsheet, that way the imp...

I'm not going to lie; it's not a perfect, exhaustive list of absolutely everything you want (you will definitely need to tweak the formulas a bit) but...

I would start with Power Query. In the video she's using an older version of Excel, in 2016 and on it comes standard in the Data tab under Get and Tra...

Hi Robert! Use Index/Match to find the range you want inside a Sum. =SUM(INDEX(Table1[[Product A]:[Product E]],MATCH(I3,Table1[Size],0),MATCH("P...

When grouping by the date are you selecting a month grouping? I would check that, if that doesn't work, a sample of your project would be helpful to s...

Row labels is the default pivot style in excel. If you want to change it click anywhere on the pivot table>design>report layout>show in tabul...

Merged the queries and my life feels more complete and accurate now! Thanks so much for the advice, I really appreciate it!

You're looking for a simple Vlookup. In your original highlighted columns I used Xlookup if you have Microsoft 365; otherwise, in the non-highlighted ...

Something like this. ActiveCell.Offset(rowoffset:=-1).Select UserForm1.TextBox1.Value = Sheet2.Cells(ActiveCell.Row, 1).Value UserForm1.TextBox2.Va...

I would use offset. Offset 1 row for next record and offset -1 row for previous record. Just copy the code to fill the form and instead of cells.value...

Hi Jose, Here try this. Double click on a row in Disc_Code to bring up your userform and the update button will update your information and unload ...

I just saw a video on this recently, one is to publish it to the web and grab the web address to import it that way. The other requires VBA and a 3rd ...

Hi Rachel! Thank you but I am far from an Excel genius. =IF([@[Days Complete]]>0,IF(SUMPRODUCT((Table1[Project]='Project List'!$B5)*((Table1[...