nice

I have 200 links to different workbooks that I need to turn into tables/data. =+'https://onedrive.com/Documents/[File1]Sheet1'!E1 =+'https://onedrive.com/Documents/[File2]Sheet1'!E1 =+'https://onedrive.com/Documents/[File3]Sheet1'!E1 ... =+'https://onedrive.com/Documents/[File200]Sheet1'!E1 I...

Good Morning, and thanks for the help. I am working with a string of 169 grades (numbers), >90, <70, 80-89, 70-79 I am good with countif on the >, < but need help with those two ranges. Is countif the best formula to use, and if so how to i use it for the ranges, and if not what would you...

Hi, Is it possible for a simple code for which when the worksheet is open the first entry in the drop down list is selected. have a nice day.

hi all i have got this far with the formula =IFERROR(VLOOKUP(B8,P8:Q1265,2,FALSE),"ERROR! ") I would really like to not show the "ERROR!" until there is a number in Cell B8 is there a way to do this? Hopefully i have explained what i need lol (Trying to learn so please be nice lol) Thanks...

Is there a way to tag a post to follow? In other words, it would nice to be able to refer back to see what the resolution to the issue was. Thanks!

Hi there, I have a macro to auto zoom to a range when someone enters a sheet as this is where all the input fields are: sub enterSheet() ActiveSheet.Range("T1:CZ1").Select 'set range zoom ActiveWindow.Zoom = True end sub Is there an extra bit of code that I can slide in there to center this...

everynumber = Application.WorksheetFunction.CountIf(Range(“A1, AD1000”, ">0")) Hi! It just doesn't work, I tried everything to get along with this CountIf Function but I just doesn't succeed. Could you help me out please? Have a nice day!

Hi, I am trying to find the common/repeated text in Cell A2 AND Cell B2 and show the results in Cell C3 Eg: Cell A2 Nice Job, agent 104 Cell B2 Great and nice, but what about 106 Result Cell C3 nice Referred some of the posts but they compare with the whole column which is not required...

I have a series of numbers in a cells in a column e.g. 5632 4361 3343...

I have seen many posts about this but have not really found anything that works for me. I am looking for a hotkey or macro that allows you to go back to the previous cell selected. I am currently using 2003, and I have tried F5 / CTRL+G, someone else mentioned somewhere to try CTRL + Backspace...

I would like to be able to select different cells, like A4, B2, C1, E5 and have them concatenated in 1 cells whereby I am asked for separator to be used, like space, or comma, or semi-colon separated So, instead of manually adding " " each time in =CONCATENATE(A4, " ", B2, " ", C1, " ", E1)...