Forum

Christopher Williamson
@prof_fr
Eminent Member
Joined: Aug 22, 2024
Last seen: Mar 31, 2025
Topics: 5 / Replies: 13
Reply
RE: Help with VBA

Good afternoon Charles Thank you so much for your reply and script. I played around with it - silly me - and in the end got myself in a real twist...

1 month ago
Topic
1 month ago
Replies: 2
Views: 244
Reply
RE: FS function across two worksheets

Fantastic Wonderful Superb Can you help with VBA as well? Best wishes Chris

1 month ago
Reply
RE: FS function across two worksheets

Thank you - worked perfectly. I have now amended each of the colums on the Schools and Data sheets which I hope makes things clearer. On reflectio...

1 month ago
Reply
RE: FS function across two worksheets

Apologies - the heading was wrong - it should have read Data Validation across two worksheets

1 month ago
Reply
RE: Fiscal year - calendar year - help and advice, please

Good morning Mynda Thank you for your help in the past. We are fast approaching a new fiscal year. All my company data in in a folder (HST data)...

1 month ago
Reply
RE: auto update pivot table from data in a folder

Good morning I have been preparing data for to add to the query. The previous owner of one of thebusinesses had some data which I can transform ...

6 months ago
Reply
RE: auto update pivot table from data in a folder

G'day and Thank You I am new to the world of pivot tables and even newer to that of power query. So I have, I think, "got it" and will follow...

6 months ago
Reply
RE: How to remove duplicated headers when importing from folder

Apologies Catalin I just can't seem to make this work. It's clearly something I juast don't get. My data is at the place shown on the attache...

8 months ago
Forum
Reply
RE: One-click data consolidation

Strålande. Tack så mycket. The original "issue" was solved by making sure each sheet had the same format: "sheet 1" and not a mixture of "shee...

8 months ago
Reply
RE: One-click data consolidation

I wonder if you can help with this new little "niggle" I follow all the steps, make pivot tables but when I "refresh all" i get an error which...

8 months ago
Page 1 / 2