confused

Hello, I created a simple flat DB and posted it on our share drive. It is one table, one form, one report and an export to excel. There is a menu table that has 3 buttons on it, 1 to open the form, 1 for the report and 1 to export.. I have had 4 people attempt to open it, 2 can, 2...

Hi Excel gurus, I have an Excel 2010 spreadsheet with two main tabs "Input", and "(HIDDEN) RAW DATA". "Input" has a row of data (range = CA3:SY3), which I want pasted into a table in "(HIDDEN) RAW DATA". Cell "Input!BZ3" contains a person's name, which is variable (dropdown). "(HIDDEN) RAW...

I inserted a command button into an existing excel spreadsheet. I went in vb editor for the button to write the code for the button's function. However, when you click the button, nothing happens. I think I forget/missed the line to make it do the macro. Does anyone see what I missed? Option...

Hello all that read this thread. I'm very new to posting this sort of problem, or indeed any problem over the internet. So apologies if I dont quite get across what I am looking for. I'm also have only basic knowledge of Excel, so please be patient if I don't seem to quite understand. Problem...

I am currently trying to solve a formula and am unsure as to what the best way to go about it is. I want to count 1 if the following conditions are met: A = no B = any text C = any text D = any text E-J = at least one has any text If all these conditions are met, count 1. I've tried...

Hi All, I am very new to this and have been assisted to utilize VBA code for an excel spreadsheet. After a number of months using the code i realized that the intended operation was not happening and instead i started to loose data. The reason for the code that i have is to move a row of data...

I'm having a bit of difficulty getting Excel to play nice. Simply put, i've got a Pivot Chart that doesn't know which its xlValue axes are. I have a piece of VBA to format the chart that sporadically works and then gets confused again. I've tried everything I can think of to get this working...

Hello gracious gurus, I need assistance with dependent list boxes. I have reviewed about 7+ videos and cannot find my answer. I need a formula that will show a List Box based on formula. For example, if I select model "CT4-3/8" then, I want to have the "LB_TB_Fifteen_In " List Box choices...

Hello All, I have a field in which a user must manually enter a date. The date field is used to caluclate a number of different cells which have IF Commands in them. The problem occurs when that field has not been entered it displays the value "0-Jan-00" (likely because I have that column...

I've been searching for an answer to this for some time but the keywords always bring back the wrong results:???:. I'm trying to run a simple for loop but when it starts running it starts with the "to" value:confused:. i.e. For A = Top to Bottom do something Next A In this example, lets...

Hi everyone, I've spent a few hours search the forum and haven't found a solution yet, so wondering if someone can help me out, or point me in the direction if this has been asked before. I have an Excel Spreadsheet that has 17 Columns, and will eventually (throughout the year) have roughly...