multiple lines

Hello, i have modified a couple of formulas I found, but am struggling to make them dynamic enough without having to edit the formula when copy pasting. All of this data below is reading from another sheet based on "JOB DESCRIPTION 1" field. Is there a way I can modify this formula below, to...

Hi, everyone, I have a text file that produces the information below for each record. I need each record on a single row in Excel so that we can sort the information by date. My colleague, Leslie, is in the process of discarding these Chromebooks as they become irreparable through student use...

I have a spreadsheet exported from MYOB ... The format makes it useless for my purposes without a lot of manual deleting and copy/paste, so I'm trying to clean it up automatically. 4 Columns: <tbody> A B C D Row Number Product ID Product Name Date Quantity 1 Prod-1-Code Prod-1-Name 2...

Scenario: User presses button input box opens user pastes several lines of text text gets pasted in column A each line in different row. Do I use inputbox for this or userform? Managed to create inputbox but it only gives me one line Don't know uesrforms

I have a tab with a list of files in multiple folders, with the folder name too. On another tab I have a list of notification numbers, eg. 12345678. Multiple files (lines) will have the notification number with the file name: Filename: -026D0003 12523032 IWS.pdf -026D0003 12523032 TQ...

I'm trying to find a workaround for the fact that Quickbooks does not have a suitable solution for printing donation receipts that comply with Canada's CRA guidelines. We are not actually using Quickbooks yet, but we need a more formal system, and this seems to be the preferred option, with the...

Hi, how would I perform the below using either formula or VBA? Thanks <COLGROUP><COL style="WIDTH: 48pt" span=7 width=64><TBODY> From ('Sheet1') To ('Sheet2') Position HC PA Position HC PA Test1 5 RIG1 Test1 1 RIG1 Test2 1 RIG2 Test1 1 RIG1 Test3 8 RIG3 Test1 1 RIG1 Test1 1...

Hi there I'm wanting to return a value based on a reference IF another value in a row is between a certain date range. For example, out of all of company X's products, I want to look at the listings that were released between 1/2/13 and 1/4/13 and return the product code if those conditions...

I have a excel master spreadsheet where sheet 1 contains a list of the residents in the subdivision. For example <tbody> L. Name F. Name Address Street Email Phone Children adam john & mary 123 main qwe@yahoo.com 999.000.8888 Mark Aray bill & sue 345 first asd@earthlink.com 111.222.3333...