Search:

Hi...I have a pdf document which has several tables with titles and headings. Each table is a department. I need to convert this into excel and keep the formatting.

Ideally I want to save each...

Thanks how can I automate the recipient, subject and text in body?
Also is there an easy way when the user clicks on the link to reply for a box to come up for the user to type in their department...

Hi...I have a code which I use to email out reports to users which is working fine. I now want to ask them to confirm they have read the reports by replying to an email address.
I would like a code...

Hi Pete this is the bit of the code which copies the data from sheet 2 to sheet 1. It looks like all the rows are being copied over even after the initial lookup.



Edit / DeleteEdit Post ...

Thanks Pete. It is excluding the "subs" which is great but what is happening now that after the first part of the lookups between sheet 1 and 2 the code is also adding all the codes with the figures...

Thanks Pete yes I mean not copy across to sheet 1.
I'll try this out. Thanks again.

apologies i hadn't set the dim for c and c1.

The code works Pete but one thing I've noticed is that on sheet 2 we have a code for expenses (code is subs) which should appear on the variation...

I'm getting a debug error on



For Each i In c1

Thanks so much Pete. I'll try it and and let you know how it goes.

Thanks Pete

Thanks Pete

Where is is a budget figure but no contracted figure on the second sheet it is adding it to the variation section which is perfect. But now I need to add to the variation section on the first where...

Hi Pete...I'd really appreciate your help with this last bit. Thanks.

ok thanks Pete

Hi Pete I'd really appreciate your help with this last bit please. Thanks

Hi Pete...have you had a chance to check this please?

Hi Pete...i checked a report where is no budget figure on the first sheet but there is a contracted figure on the second sheet. This didn't add to the variation section.
So we could have...

That's perfect. Thanks so much. I'll try it out with multiple reports.

Thanks so much for your help Pete.

Hi Pete...the code runs without any errors but doesn't do what's required.

Where there is a value in the A1 Budget column for a code on the first sheet but no value in the A1 contracted column in...

1234 could have multiple sub codes like

1234 Grade 2 9999
1234 Grade 2 AB12
1234 Grade 2 66YY

so for the look up i only want to pick up the first line with 1234, in this case 1234 Grade 2...

Hi Pete

Does this example help explain what I need to do? Thanks

Hi Pete...have you had a chance to check the example file I attached to explain what I need the code to do? Thanks.

Thanks Pete. I'll try it out and let you know.

sorry Pete. The row and column headings are the same for all sheets but the values in row/column will be different for each sheet so I want the values range on the Y axis of the graph on each sheet...

The rows and column headings will be fixed on all sheets. Thanks

OK I am attaching an example workbook.
On the first sheet 4444 there are 3 rows with the same initial code 1234 and then three different sub codes. I want to only pick up the first row 1234 Grade...

Hi Pete...please help with this if you can. Thanks

Yes range of values. Thanks

Thanks Pete. How can I set the amount increments dynamically for each sheet?

Hi Pete...on the first sheet where the variation section is being added there are some codes which also have a sub code against it so there could be multiple same codes but with different sub codes...

Thanks Pete. I managed to rename the sheets (above code) on the original sheet so may as well add the graph on the original and then copy over to the saved workbooks.
Can you please help me with...

Here is the first part of the code which i want to use to format the sheet and rename the each of the sheets on the workbook.



Sub Trend()


Dim sht As Worksheet, wb As Workbook, fnd As...

Here is the macro i recorded for the graph


Sub Graph()
'
' Graph Macro
'

'
ActiveSheet.Shapes.AddChart.Select

Thanks Pete.
You have helped me so much with this and I really appreciate it.
Can you please help me with this last bit where there is a budget amount on sheet but not a match on sheet 2 it...

Thanks Pete.
You have helped me so much with this and I really appreciate it.
Can you please help me with this last bit where there is a budget amount on sheet but not a match on sheet 2 it...

Hi Pete...i was planning to record a macro to create the graph but I'm not sure how to do a loop to add the graph to all the sheets.


The end goal is to add each sheet from this new report to...

Hi...there is a report with over 100 sheets. I need to rename each sheet to pick out a 4 digits from the sheet name so it will be something like mid(11,4). To the 4 digits I want to add the work...

Ok Pete managed to get it to work. I changed the count to - 100. Random number I picked and it worked!


If fndval.Row = dt.Rows.Count - 1 Then Set fndval = fnd.Offset(dt.Rows.Count - 100,...

Thanks Pete. I still get the error on the same part of the code. Can you please tell me what this part of the code is doing so I can understand maybe that will help me try and find the issue.
...

Thanks so much Pete. Really appreciate your help. It works for a couple of reports but then I get a debug "Application-defined or object-defined error" on this part of the code

Set fndval =...