building

Hi everyone, I have a database where a number of rows of a single column need to be copied (transposed) to a single row and alternating columns. For example, if my data was in A1:A10, what I need is to copy it to a different worksheet into columns A1, C1, E1, ...S1. Before I engage into...

Can someone help me figure this out? I've tried with vloopkup/index match and looked into the Solver add-in but can't find a property solution. I have 5 unit types, each of a certain size (square feet). I have 4 building types each of a certain size as well. For each type of building (e.g...

Hello, I need some help with building an array for a auto filter. At the moment it is not filtering / handling the value correctly. My code I have at the moment is below: Sub Test() Dim nDates as Variant Set rng = .Range("A2:B" & nRows) nDates = Sheet1.Range("L2:M8").Value...

Hi All, I am trying to count the days building up to TODAY() but the DATEDIF doesn't seem to count before the TODAY() date Any ideas how to show in days a date prior to TODAY() THanks

I have created 8 tables that I need reference for building out another table called ReportBuilder. I am new to Access and need some guidance. for building out the ReporBuilder Table, I want to reference the DeptXRef table and in the ExcludeDept field if it says Data Dependent, to copy the dept...

Hello, How would I copy and paste a selection a bunch of times on a given interval. Example: I have an excel file that has a value in it, like building 1. There are then 4 spaces after that text in the excel file. I need to copy the value "building 1" and paste it into cells A2-A5. Then...

I have for some time been building staff managing tools in excel with VBA and userforms. I have only googled what i need and solved things by asking on this and other forums. I have never looked at Access but i understand it could have the potential to do what i am doing in Excel but maybe in a...

Hello, If I have a Large range and I want to create an array from it but with conditions, I am trying to find the fast way to do this, possibly Advanced filter? (I have tried but no luck) there are probably many ways but the fastest? or pretty darn fast at least My ranges are dynamic but...

I'm struggling and need help to do the following: I'm pulling text, which can vary depending on the original result, from one sheet to another. This will show in cells E5:E24 and F5:F24 (not merged). For example, after one review E5 could say "Building" and F5 could say "Post 01.06.2004"...