data input

Hello, I have received some great advice on here before and I'm hoping someone can help me again. I'm looking to enter a date in cell G2 on sheet 1 that then looks for a matching date within cell F2 on all the other sheets within the same workbook (each day of the month has it's own sheet) and...

Hello, Any help to speed up my work with a very outdated website is very appreciated! I currently am manually typing thousands of data inputs out to 6 decimals into an EXTREMELY outdated system that I have no control over. Each project requires 10 inputs into the form. You can not tab...

MrExcel Forum, I have a question I was hoping someone here could help me answer. Is there a way for me to input data into the same cell across different workbooks, similar to how you would for selecting multiple sheets and adding a value in a cell (i.e., typing 5 in selected cell A2, on sheet...

Hello Everyone, Hope you are all doing well. Happy Friday! I have a question about values in an IF formula. Im trying to write an IF formula that will recognize a number between 0 and 1. When this number is inputted the formula will be TRUE, otherwise it will be FALSE. Here is my example...

Hello everyone, Hope everyone is doing well. I am trying to design a spreadsheet that will be used to record information from invoices. One column in this spreadsheet will be used to record the store number that the invoice originated from. This number has to match the invoice or else...

To start, I am very unexperienced in VBA. I have an excel workbook with two sheets "Input" and "Database" I need to create a code so that I have a command button on the "Input" sheet that will transfer the data that will be inserted into a "table"(just a 24 row by 13 column section) as shown...

Hi everyone, really hoping you can help me on this one. I'm creating a new Time in Motion sheet for my team, and I want to programme a Command Button so that when it's clicked on Sheet 1 it prompts for a reference number to be input, then that reference number is fed into (say) column D on...

Hi all :) I am having real fun here,, I have a constant flow of data that is coming from a different program that inputs its results into a cell in excel. What I am trying to do is set up excel to move down to the next cell at a set period, say every 15 mins, so that the data stored is in...

Hello, my name is Dan I work for a church that calls groups of persons for a food bank I want a simple one cell input i.e. type in group # or use drop-down then that number that is input is added to next blank cell either row or column i.e. I type "4" into cell a1 (or select from...

:-?I have a spreadsheet that is setup as a master template to accommodate 105 rows of data input. How can I make it display and print only the rows that non zero values have been entered. The final print needs to contain rows A1:A12 and A118:A129 along with A13:A117 containing non zero values...

I was wondering if anyone can help me, I am creating a number of charts that need to be updated annually. I am looking to make this as user friendly as possible and would like to find a way to input data into the original data source (worksheet) and for the chart to update automatically. i.e...