managed

Hi! I would like to get all text value on a worksheet into one variable. I managed with cells, its obvious. ... Sheets(Sheets.Count).Select For Each cell In Range("A11:EE500") t = t & " " & LCase(cell.Value) Next cell... But stucked with other object which should have text value. So far i...

hello, see if i can explain this well. on sheet 1 column A i have a list of unique IDs (surveys), column B is the date of the survey (in form of month), column C is unique identifier for who took the survey on sheet 2 i have the unique IDs from column A sheet 1, column B is a list of unique...

Hello, I am using the code below to add a record, but I’m getting a run-timeerror ‘3464’: Data type mismatch in criteria expression”. What am I doingwrong? Is it the spaces? CurrentDb.Execute "INSERT INTO archive_RET_Accumulated([REF_NUM],[Exam ID], [Exam Name], [Exam Agency], [OCC SL No]...

Hi I send out a report once a month to about 50 different people so they can fill it in and return it to me. I recently tried locking ranges of the report to try and reduce the amount of errors I was seeing in their submissions. However I just got a report sent back with a complaint that they...

Hi All Hoping for a little bit of help please - I'm not great with VBA so have developed a code based on adapting others. I'm trying to transpose information from one sheet into another. I've managed to do this so far, but I need to update the code to paste values. Can anyone help? Thanks in...

I have a normal table of data, in most cases the data is vertical, however, within the table is some data that is horizontal, by this I mean running along the columns as opposed to in rows. I have managed to create a pivot table by adding calculated fields of the same data in the columns...

Can someone help? I have a workbook which i run various filters on. I need a code to copy whatever cells shown from A2:Q7000 to a new workbook, could someone help please? I managed to code to create a new sheet but its causing me issues so wondered could someone assist?

Hi all, I had a rather large spreadsheet to track some things, and I had to split it out into several smaller workbooks. The original still references all of these other ones, and so consequently all of my SUMIFs and COUNTIFs didn't work. I've managed to get around some of these with COUNTA...

Hi, Has anyone else on here experienced the issue described on the thread below? :eeek: http://community.powerbi.com/t5/Desktop/Each-data-refresh-gives-different-data-results/td-p/60989/highlight/false If so, are you still having issues or have you managed to work out what the cause was...

Hi, i'm trying to get an an amount allocated across a few lots based on its rank. I managed to do this with the formula below (table starts at A1). For apples =MIN(C2,$B$10-SUMIF($E$2:$E$4,"<"&E2,$D$2:$D$4)) For bananas =MIN(C5,$B$11-SUMIF($E$5:$E$7,"<"&E5,$D$5:$D$7)) Now instead of writing...

Hello Everyone, After a lot of thinking and reading I could not find a solution, so I thought someone might be able to help. I managed to return first and last word from a cell, even managed to return the Nth word from a text, but could not manage to find a function to return Nth word, if...

I have just taken over a spreadsheet previously managed by a colleague. It's very simple--just a database with columns (last name, first name, address, etc.) No functions, no formula. It was saved in Excel 97 as recently as last month. I have managed to clean up lots of formatting, but I keep...