figured

I have a dynamic report that lookups a couple of comments columns. Depending on size of text I would like to expand the rows height to meet the needs of the lookup. So default the row to 12 unless it needs to be expanded. Was going to write macro to do so but figured Id make sure there was no...

I need to put a pivot table/chart together for data that is in 4 tabs of my excel spreadsheet, however I haven't figured out how to do so. I can do it for each tab individually no problem. any help would be appreciated. Thanks.

Hello: I have figured out how to send a gmail or outlook email, adding spreadsheet ranges to the email body, and adding file attachments to the email using vba within excel. The one thing that I cannot figure out (and have searched extensively), is how to create a gmail draft and not send it...

Please Help, I have been searching the internet for an answer but cannot get what I am looking for. Here is what I need to know how to do: ActiveCell.Offset (0, E40).Select ActiveCell.Offset (0, "The value of cell E40").select It seems so simple but I have not figured out a solution. TIA.

I want to be able to trigger a subroutine when I click on a certain cell. Presumably clicking on any cell would trigger the sub; but I can put code in the sub to determine if the selected cell meets my criteria for action, and if yes, what that action should be. So far I haven't figured out how...

I am trying to make a chart to figure weight lost gains and losses per person. I need the beginning weight for the month with week 1's weight, week 2 and so on. I also need, in between the weeks, the gain or loss amount which I have figured by subtracting the two. When I get to the end of the...

Dear all, I'm trying to auto-populate a grid-like seating plan from a list of names. An example of the sequence is as followed: <tbody> name 1 name 5 name 9 name 13 name 2 name 6 name 10 name 14 name 3 name 7 name 11 name 15 name 4 name 8 name 12 name 16 </tbody> I've figured out how...

Hi Newbe here well kinda of an oldbe but that was a long time ago and a few emails back. I want to create pop up comments based on pivot table fields. They are actually team replies to earlier reports and figured it would eb a goo way for management to get the notifications. I already have it...

I know this is probably simple, but I'm trying to add two cells and then divide by another cell. So far I have this =a2+a3/a4 and it doesn't work. Sorry. never mind =(a2+a3)/a4 figured it out.

Morning, I created this formula (see below) yesterday and I've just realised that it's not working and I've figured out the reason... How would you change it? =COUNTIFS('Tier 3 Tracker'!$F:$F,"<=30/09/2017",'Tier 3 Tracker'!$Z:$Z,">=12")-COUNTIF('Tier 3 Tracker'!$AT:$AT,"<30/06/2017")...

Hi guys, I hope you can help me, as I've tried many different options and am out of options (excel will not accept my formula). I am trying to construct data validation *custom*, where user can only insert phone number OR email address; this is what I have figured out so far...

Hello I kept getting error when I'm trying to save a file. I copied some cells from an Open Office sheet. I removed non pertinent cells to keep only the format and placement of the form. Error mentioned is about calculation parameter that may not be compatible with Excel. How do I found...