c4g

I need to reference data from one sheet to the other and the sheet name can change and the cell needs to be relative so if a line is added in the other sheet the reference is not lost. I tried using Indirect with the name of the sheet in cell C9, which changes, =INDIRECT("'"&$C$9&"'!"&"D23")...

There is a lot of info on dynamic ranges but I can't figure out how to put it together for what I need and hopefully someone can help me. I have a spreadsheet with the headers on row 1 col 1 to col (whatever) and the data right below it. I need the macro to select all the data from row 1 down...

I'm trying to figure out how to create code that will look at each cell in Col C and if it contains the text "total" to leave the cell contents in Col D alone. But if it doesn't contain the text "total" to clear the contents of the cell in Col D. How do I do that? Any help greatly appreciated.

I have a spreadsheet where I thought just copying the last two columns and pasting them to the right of the last col would work. But I found that won't work to maintain the formulas in the report from month to month. The two columns are basically Monthly report data that is pulled in via...

I have a spreadsheet that needs two new columns added to the far right of the spreadsheet every month. The added columns need to have the same formulas and formats as the previous two columns. I found code that will Copy one column's format but I can't figure out how to modify it to have it...

I've looked on all of the forums and I can't find an example that solves my problem, so I'm hoping someone can help me. I have a workbook with the following tabs in this order: Summary 2011 2012 2013 2014 Direct Labor by CC Forecast Collection 2011 Forecast Collection 2012 Forecast...