ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   if then statements (https://www.excelbanter.com/excel-worksheet-functions/190466-if-then-statements.html)

mercy

if then statements
 
can i use if then stmts to import data from multiple cells into one? I have a
spreadsheet that I load cash totals in per day. Each days info is entered
into a different cell. I want to import each days total into a summary daily
cash spreadsheet. I don't want the totals to be cumulative. For example, cell
I69 would be June 7ths jackpot totals. I70 would be June 8ths. I have another
spreadsheet that combines the jackpot total daily with all other cash totals.
I only want to import the jackpot total. Is there a way to do that?

ytayta555

if then statements
 
Hi

Try to use CONCATENATE Excel function to import data from
multiple cells into one

mercy

if then statements
 
I'm not trying to import multiple cells into one. I am trying to import cells
that are constricted by their date. For example: I log jackpot earnings into
cell I60 for today. Tomorrow the earnings go into J60. I have another
spreadsheet that takes the days earnings and subtracts the current jackpot
earnings. (call it "DCS") I want to tell the cell in "DCS" to only import the
current day's jackpot earnings.

"ytayta555" wrote:

Hi

Try to use CONCATENATE Excel function to import data from
multiple cells into one



All times are GMT +1. The time now is 11:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com