thinking

Is it possible to have a recordset object created in one workbook but access this recordset object from another workbook's vba code? I was thinking maybe getobject could be used to capture it from another workbook but I cannot find any resources on this.

At least, I assume it's that part of the formulas that's causing the problem. I created a cover sheet for a co-worker's workbook to summarize his data from the other sheets. The main sheet that's referenced had upwards of 9,000 rows, so the SUMPRODUCT formulas on the cover sheet are very long...

Here's my formula right now: =COUNTIFS(Q$2:Q$1127,$B1136,F$2:F$1127,"Y",$A$2:$A$1127,"Provider") I want to COUNTIF $A$2:$A$1127 contains "Vendor" OR "Investor" along with the conditions for ranges in Q and F. I tried...

Add numbers up in column C that don't have the word (equp rental) name in column D. I was thinking =sumif <> equp rental, DD I don't know

I have a Excel spreadsheet for users to input the data and it came with all the formula for auto calculation etc. The file size is getting big. I was thinking to learn and switch to MS Access and would like know can Access able to perform the auto calculation as what Excel does?

Hello I would like to write a formula that would give me the number of EU countries listed in a single cell. So for instance if I was to check the below cell the result of the formula would be 3. CELL A1: Australia,China,Germany,France,South Africa,Spain There are 28 EU countries so I was...

how can i use a macro to remove duplicate lines in my text file such that the last one will remain, for instance the boy is good great thinking great thinking he lives the boy is good what's up great thinking it should now be like this he lives the boy is good what's up great thinking

HI I am struggling with this. Is there any way to add a filter to disregard the blank columns but still ensure I am reading to last row of data? I was thinking I need to do an xlup function? can I only apply the filter this way using VBA? thanks for any advice.

Hello good people! I'm creating a single spreadsheet for a daily report. Since there's a report every day, I've created 365 tabs each with a brief short date (01_01, 01_02, 01_03, etc) It got me thinking... is there a method for hiding tabs based on date using the tab name as a filter? IE...

hello yall Im tring to do a DV in VBA code where if A1=Yes then value in D1 must be between 1-120 and if value in A1=No then value in D1 must be between 121 - 150 Im thinking I need a DV in VBA Code. I already have a DV for D1 so I prefer a VBA. Any suggestion is greatly appreciative. Thanks

Hi All, I need an output that displays the URL in column A (Old URL) that most closely matches the URL from column B (New Url) The product name & code number stay the same in both A & B there are just some extra categories in the column B list The output needs to be Something like Column A...

Hi, Hoping someone can help me with formula. I need to total pay components in one column be cost centre but the totals need to appear in a different worksheet I only want to pick up certain pay components though eg salary, Overtime etc Thinking I need an Index Match and Sumif or Sum product...

I have the following formula working: =COUNTIFS('Detailed Incidents'!$D$2:$D$1000,”New Jersey”,'DetailedIncidents'!$I$2:$I$1000,”Newark”,'Detailed Incidents'!$B$2:$B$1000,”January*”,'DetailedIncidents'!$B$2:$B$1000,”*2018”)) But I want to include if another corresponding column hasANY of the...

I am trying to solve an issue. =ifs(PasteMDMCoverage!E2="",Index(PasteMDMCoverage!F:F,match('Workforce Template'!E2,PasteMDMCoverage!B:B,false),01),if(PasteMDMCoverage!E2>0,Index(PasteMDMCoverage!E:E,match('Workforce Template'!E2,PasteMDMCoverage!B:B,false),01)) if there is no number in E...

Hi. Some background. I work on a vessel laying subsea cable on the bottom of the ocean. Usually we need to draw this cable position in XY, and also in Z. For the position in Z, we generate a profile view along the XY position. Giving the orange line in the attached screenshot. However, since...

Hello guys, I've written some VBA to control some checkboxes but it's causing an issue that I can't quite get my head around fixing and was wondering if anyone here had any ideas. So basically I have a stacked bar chart. I have a list of options (about 20) that can be individually clicked to...

Does anybody have a sample they can point me to which has an help UserForm to display to user to give them help on certain attributes of a spreadsheet? I found this one on contextures, but it's a multi form and I'm thinking more like a dropdown box with choices. Anybody know where to find a...

Hi What i am trying to do is type the first number in Column E where the yellow is and drag it down. If the number dupes in Column D like you can see the 3 and 6 and others. I need the number to stay the same before it changes and goes higher. The number in E2 will always be different every...

For the life of me, this isn't working.. In Column J.... there will either be 2 texts included = "SEL-", or "INC-" If neither, then it should default to "BI" I was thinking of using this: =IF(FIND("SEL-",J:J,1)>0,"SEL","BI") But I need to it first check for "SEL-", then "INC-", then default...

Hi I have a table like the one below. What I want, I want to create dynamic chart that show one grade at a time. So if a user select A then the percentage of A will appear as below and then the chat will show A and its %. I am thinking that could be done with data validation but I not sure how...