Mar 16 2022 05:01 AM
Never posted here before, I find these forums complicated to use, can I not upload a small excel sheet for someone to help me edit?
Mar 16 2022 05:17 AM
If you don't see area with a dotted border and text "Drag and drop here or browse files to attach" below the box where you compose a post/reply, you'll have to upload a sample workbook to a cloud service such as OneDrive, Google Drive, Dropbox or similar, then obtain a link to the uploaded file and paste the link into a reply.
Mar 16 2022 05:24 AM
Mar 16 2022 05:26 AM
I am in full text editor but can't see any browse option!
Mar 16 2022 07:55 AM
New users often don't have the option to attach a file. That's why I mentioned alternatives.
Mar 16 2022 06:10 PM
Mar 17 2022 01:13 AM
If you have a Microsoft account, you can use OneDrive.
If you have a Google (Gmail) account, you can use Google Drive.
Dropbox and Box have free versions for private use.
Mar 17 2022 05:02 AM
Mar 17 2022 04:24 PM
Mar 18 2022 06:19 AM
I was able to download the workbook.
However, I don't understand "by typing this word (MO) I would like to change the results of D2,D3,D4 to $6000, $0.00, $1000 like the example on row 6". Do you really mean D2, D3 and D4?
Mar 18 2022 06:15 PM
Mar 19 2022 04:02 AM
Do you want B2 and C2 to remain unchanged if you type MO?
If so, you'd need VBA code instead of formulas.
Mar 19 2022 07:06 PM
Mar 20 2022 05:17 AM
It's still not entirely clear to me where exactly you will be entering the product names. In your sample workbook, do we need to take A3 and A4 into account? Or A3, A4, A5 and A6? Or something else?
Mar 20 2022 05:38 AM