Posts by Craigside

Hi thanks for reply.

For many years I've been selecting/copying and area of cells containing an image plus info (excel'07). I paste it onto a 'sales sheet' worksheet with same format but cell size sizes are smaller (I've now realised). It's always worked fine until now. I realise that until now the excel has been reducing the size of the pasted image to fit the area.

Now it isn't reducing the image size so it it twice as big and overlaps (in excel365). A real pain tbh.

Many thanks for any suggestions.

I've moved my large business SS from excel 2007 to Excel365 (to work with my new win10 laptop). My SS is to manage artworks, and has 100's of images in a worksheet along with data. What I am experiencing is;

I 'select' an area of cells that includes an image and data, I go to the worksheet I want to paste it into, select the location and 'paste'.

Usually, in excel'07 the copied cells are pasted straight in and the image automatically fits the space (the cells are smaller in the target worksheet).

However, in this excel365 I paste the contents and the image stays large, ie. it doesn't automatically shrink to fit the space?

Any help much appreciated.

Also, how do I mark my post as 'answered'?

Thanks

Thanks Roy, I didn't know how to do it...

test test test

Oh wow thank you!

Much appreciated.

I've been running my spreadsheets on excel '07 for many years. I've just moved to a new laptop with Win10 and discovered my Office2007 won't run my Excel on this Win10 laptop - it just freezes, macros won't run, etc.

So, I'm on the Win365 excel trial. This seems to be working overall, however I've now got a simple macro that won't work? The macro is to delete the contents of a column on more than 1 page.

I don't understand why it's not working. I get a runtime error '424': Object required.

When I click the debugger the line is highlighted as per;

Sub ClearLabelList2()

'

' ClearLabelList Macro // This will clear the Label List Column across multiple sheets

'

Dim Shts, ws As Excel.Worksheet

Shts = Array("Repros", "Detail List") '// Change list of sheet tab names to suit

For Each ws In Sheets

If Not IsError(Application.Match(ws.Name, Shts, 0)) Then

ws.[AE3.AE5000].ClearContents

End If

Next

End Sub

Any help much appreciated.

Hi, thank you! I apologise I think my mistake, it works fine!
Thanks again for your assistance.
Rob

Hi

Yes of course it runs but the postion of the data pasted from tables Data2/Data3/Data4 and Data5 are not in the correct position? The pasted rows do not maintain the correct row spacing so I do not have continuinity or useability in the resulting data.

Thanks.

Hi

Sorry for delay. I've tried amending your macro but it doesn't work properly? For testing I set the last rows as 42/33/33/33/33

please advise? Thanks

Hi
i am away for 3days I can’t look at it until Tuesday, no panic thank you!
Rob

Hi GC

Really cool. I notice a snag, after DATA2 has been pasted it adds 3 rows, please see attached example?, I have simplified my data for clarity during testing.
Thanks

Hi guys
Thanks, first time for me on this hire help forum. To be honest and fair I haven't looked at Aju's solution because GC contacted me first and said he was on with it..

Hi
Thanks, before I try this out...

Where do I specify the Data1, Data2... etc sheets to be copied from?
After copying/pasting Data1, does it start at A3 on following sheets?
Does it pop up asking me to specify bottom row number for each Data1, Data2 etc sheet to be copied and pasted into Data?

thanks

Hi

Ideally I would be able to specify the sheets to be copied from Data1, Data2,...etc within the macro code.

The specific row number varies each time so I would like a pop up to appear for each sheet so I can input the last row number to be copied while the macro is running.

I hope this makes sense
thanks

Hi
At moment I have 3 sheets of data but envisage having 5 in near future. If you make the macro so I can add additional sheet names that will be fine?
Thanks Rob

Hi

I have sheets (Data1, Data2, Data3, Data4, Data5) populated via links to another spreadsheet.

Data1, Data2, Data3, Data4 & Data5 are all same format, width range A1 to HY and each sheet goes down to a different row number.

I need a macro to do the following process;

1. I want to set the row number to go to for each sheet (Data1, Data2, Data3, Data4 & Data5).

2. Select range within 1^st sheet Data1 A1 to HY1500 (set the row in macro), Copy, go to blank sheet “Data” then Paste Values Only (eg. Paste Special>Values)

3. Then, Goto next sheet “Data2”, select range A3 to HY500 (set the row in macro), Copy, go to sheet “Data” end of previous pasted data A1501 (ie. from row set in macro), then Paste Values Only (eg. Paste Special>Values)...

4. Then, Goto next sheet “Data3”, select range A3 to HY300 (set the row in macro), Copy, go to sheet “Data” end of previous pasted data now A2001 (ie. from last pasted data), then Paste Values Only (eg. Paste Special>Values)...

5. Then repeat the same for Data4 and Data5.

I will end with “Data” containing the pasted values from Data1, Data2,....to Data5.

Many thanks

Rob

Re: VBA Help needed to tweak my Search and Find macro...

Hi, Thank you!

Re: VBA Help needed to tweak my Search and Find macro...

Not what I'm looking for because I've a big SS with same items appearing in multiple sheets, thank you for trying its much appreciated!

Re: VBA Help needed to tweak my Search and Find macro...

Thank you, I think this is fine! Many thanks.

Re: VBA Help needed to tweak my Search and Find macro...

Sorry doesn;'t quite work properly...
When the search string DOES exist in the records, it pops up message "Search item does not exist", I then close popup and it goes to the desired cell?

If the search string DOES NOT exist, it pops up the same message 3 times?