PLS HELP How can I fill the columns automatically from another excel sheet?
I don't wanna lose my time with copy-paste. I need to fill an excel sheet automatically from another one but the columns are different. As you see the photos below, I need to fill the columns in first sheet with the same colour in second sheet. I used colours just to understand easy normally there are no colur in columns.Transferring data from multiple sheets to a summary sheet
I don't use excel very much, just do basic stuff on a spread sheet. However, I have a client that needs to trackpatient receipts by patient so I envision numerous sheets with cell amounts transferred to the first sheet which will be a summary sheet. I've seen these formulas before, but I don't have access to one at present and don't recall from memory. I know it's a simple formula somewhat, but just don't remember how to word the formula
