Recent content by Sabrina224

I know this is a simple format thing . . . I just can't find the correct syntax -- example: A1 = John Smith A2="The man's name is "&A1 but I want the A1 result that appears in A2 to be the only text underlined so that it looks like: The man's name is John Smith ----------...

This macro should run as soon as the cell in column A is no longer empty. During the course of the next six months, I would expect 1,400 rows to be entered. If I understand you correctly, it looks like I would need an if stmt for each possible row? -- Is it possible to run a macro from within...

I know I've seen this somewhere before, but darn if I can find it. I'm creating a tracking spreadsheet where once the user enters a copy ID in column A, the remaining columns (B-E) are populated with formulas to to lookup the previous history based on the copy ID entered. I've already created...

Thanks Vince -- all help is appreciated!!! and you're right, they want it all, or nothing. I figured I could at least get the BE setup and at least use queries and reports on existing data (making my life a little easier) until I got the rest up and running. I didn't think it was possible, but...

I have 7 users entering data in their own excel spreadsheets on their own computers (which are networked). Each spreadsheet has identical columns. Without having to physically import the data from each spreadsheet one by one into a SINGLE table is there a way to link them all to the same...

Michael, Please help me to be better at what I do and let me know why my method would be considered extra "work" as you put it. I designed a simple table in excel w/3 columns. 1st with the date/time format which Modex is looking for so the user can select for the amount of time...

Why not just use a single number field where hours are integers and minutes are decimals on a 100 base system. That way, you don't need separate fields for hours and minutes, and you can sum them up to your hearts delight (i.e., 2.25=2hrs 15min, 2.5=2hr 30min, 2.75=2hr 45min) I use this at...