Posts by Brian Walters

Can you upload a sample of what you're trying to do and how you want it to look? You should be able to change the "item*" labels without any problem, but if you change the "Model*" names on the Models worksheet, you need to also change them on the Item list sheet, or the macro won't find them. What is the error you are getting?

I redid how I was pasting the values. I also added code to clear the results before running and adds the titles to the Results sheet as well, so you don't have to do it manually.

See if you like what the attached file does.

Do you really want to replace the rows on the Models sheet or would you like to keep the Models sheet and have an Output sheet that contains the item listing?

Because the data contains multiple rows and columns for each tenant's information, the macro needs to have a starting point from which it can pull the required fields. This starting point doesn't have to be the name field, but it needs to be something whose position is known in relation to the other fields needed. I don't understand the two scenarios you are describing. Can you elaborate or upload examples?

I modified the code to do and End-Up from the used range row, which should solve the problem, but let me know if you need it to do something else.

See if the attached workbook is acceptable.

Try this:

Sub Macro3()


  Sheets("Sheet2").PrintOut Copies:=Sheets("Sheet1").Range("A1").Value, IgnorePrintAreas:=False


End Sub

Try this:
<code>Sub Macro3()

Sheets("Sheet2").PrintOut Copies:=Sheets("Sheet1").Range("A1").Value, IgnorePrintAreas:=False

End Sub
</code>

I have added a macro to add to the log and one to add the date deleted to the log. the macros require that you have the cell with the name of the tenant selected before you click the button.

Steve. It was my fault. I failed to tell you that I put a formula on the Time2 sheet to format the CC in the same format found on the CC Data sheet. I've updated your file's macro.

Can you attach a sample workbook with the data and what you'd like the result to be?

Can you attach a sample workbook with the data and what you want as the result?

Can you attach a sample workbook with the data and what you want as the result?

Can you attach a sample workbook with the data and what you want as the result?

Can you attach a sample workbook with the data and what you want as the result?

You can use the & to concatenate range values. For example if cell E9 contains the filepath, F9 contains the workbook name, G9 contains the sheet name and H9 contains the data range you could use = "'" & Range("E9").value & "[" & Range("F9").value & "]" & Range("G9").value & "'!" & Range("F9").value

Hope this helps.

Does the VLOOKUP function in the attached workbook do what you are requesting?

Can you post a sample of the data and what you'd like it to look like?

Could you attach a sample spreadsheet with the data?